How To Do VLOOKUP In Excel?

Select the cell where you want the result

Type `=VLOOKUP(`

Enter the lookup value

Type a comma

Select the table array

Type a comma

Enter the column number to return

Type a comma

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

Close the formula with `)`

Press `Enter`

Example: `=VLOOKUP(A2, D2:G10, 3, FALSE)`

Suggested for You

Trending Today