How To Apply VLOOKUP?

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`

Copy the formula down if needed

Suggested for You

Trending Today