The VLOOKUP function provides a way to add data into the dataset, using a common code or value. VLOOKUP can refer to a value in a different sheet or even a different workbook on your computer. If you click into a cell on the other table while filling out your VLOOKUP formula, it will automatically supply the reference necessary to link to the other sheet or workbook.
VLOOKUP function syntax:
=VLOOKUP(A3,$D$3:$G$10, 2, FALSE), where:
| Value | Parameter | Description |
|---|---|---|
| A3 | lookup_value | Value in our main table that we’re looking to match in the other table |
| $D$3:$G$10 | table_array | The other table we need information from (lock references with $) |
| 2 | col_index_num | The column from the other table we’re looking for |
| FALSE | [range_lookup] | Whether you want approximate matches [TRUE] or exact matches [FALSE] |