How To Do A VLOOKUP In Excel?

Select the cell where you want the result to appear

Type `=VLOOKUP(`

Enter the lookup value

Type a comma

Select the table array or range to search

Type a comma

Enter the column number to return

Type a comma

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

Type `)`

Press Enter

Copy the formula down if needed

Suggested for You

Trending Today