Select the cell where you want the result to appear
Use this formula structure: `=VLOOKUP(lookup_value, table_array, col_index_num, [range_lookup])`
Set `lookup_value` to the value you want to find (or a cell reference)
Set `table_array` to the range that contains the lookup column and the return column (use absolute references like `$A$2:$D$100` if needed)
Set `col_index_num` to the column number within `table_array` that contains the value to return
Choose `range_lookup`:
Use `FALSE` (or `0`) for an exact match
Use `TRUE` (or `1`) for an approximate match
Example exact match: `=VLOOKUP(E2, $A$2:$D$100, 3, FALSE)`
Example approximate match: `=VLOOKUP(E2, $A$2:$D$100, 3, TRUE)`
If the lookup value isn’t found, use: `=IFERROR(VLOOKUP(E2, $A$2:$D$100, 3, FALSE), “”)`
Copy the formula down/across and keep `table_array` fixed with `$` if you want it to stay constant