Excel Tip: Need to lookup a value? It’s easy with VLOOKUP! Use VLOOKUP when you need to find data in a table or a range by row. For example, look up an employee’s tax rate in a tax table as shown in the screen shot below.
In its simplest form, the VLOOKUP function says:
=VLOOKUP(What you want to look up (SALARY), where you want to look for it (a table I named Taxtable), the column number in the range containing the value to return (the second column in the table), return an Approximate or Exact match – indicated as 1/TRUE, or 0/FALSE) (TRUE in this case because I don’t want an exact match). The exact formula is displayed in the screenshot.
Contact me at email@example.com for support on the VLOOKUP function. Whether you need Excel tutoring, advice on cleaning up your Excel data, creating formulas or solving formula issues, count on me!