How To Create 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

Type a comma

Enter the column index number

Type a comma

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

Close the formula with `)`

Press Enter

Copy the formula down if needed

Suggested for You

Trending Today