How To Do VLOOKUP?

Select the cell where you want the result

Type `=VLOOKUP(`

Enter the lookup value

Enter the table array

Enter the column number to return

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

Close the formula with `)`

Press Enter

Copy the formula down if needed

Suggested for You

Trending Today