Excel VLOOKUP Formula
Learn how to use VLOOKUP in Excel with syntax, examples, and explanations.
Syntax
Copy formula manually
=VLOOKUP(lookup_value, table_array, col_index_num, [range_lookup])
Example
=VLOOKUP(A2, D2:F20, 2, FALSE)
Try VLOOKUP with Two Files
Upload two CSV or Excel files. Select matching columns from both files, choose the value you want to return from File B, and generate a lookup result like Excel VLOOKUP.
File A — Main Data
File B — Lookup Data
VLOOKUP searches for a value in the first column of a table and returns matching data from another column.
Formula Examples
| Input | Formula | Output |
|---|---|---|
| Apple | =VLOOKUP(A2,D2:F20,2,FALSE) | $120 |