How to Use VLOOKUP in Excel

VLOOKUP searches for a value in one column and returns a corresponding value from another column.

Using VLOOKUP

1. Type =VLOOKUP( in a cell.
2. Click the value you want to search for, type a comma.
3. Highlight the data table to search in, type a comma.
4. Type the column number that has your answer, comma, FALSE). Example: =VLOOKUP(A1, D1:F10, 2, FALSE)