top of page

Using Excel Vlookup function

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 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!

Recent Posts

See All


bottom of page