How To Use V Lookup?

Select the cell where you want the result to appear

Type `=VLOOKUP(`

Enter the lookup value

Enter the table array

Enter the column index number

Enter `FALSE` for an exact match or `TRUE` for an approximate match

Close the formula with `)`

Press Enter

Check that the lookup value is in the first column of the table array

Make sure the column index number matches the return column

Use absolute references for the table array if needed

Copy the formula down if you need to apply it to multiple rows

Suggested for You

Trending Today