Select the cell where you want the result to appear
Type the formula: `=VLOOKUP(lookup_value, table_array, col_index_num, [range_lookup])`
Enter the value you want to search for as `lookup_value`
Select the table range that contains the data as `table_array`
Enter the column number in the selected range from which to return the result as `col_index_num`
Use `FALSE` for an exact match or `TRUE` for an approximate match in `[range_lookup]`
Press Enter to get the result
Make sure the lookup value is in the first column of the selected table range
Keep the return column to the right of the lookup column
Use absolute references like `$A$2:$D$100` when copying the formula
Use `IFERROR` if you want to handle errors like missing matches
Example: `=VLOOKUP(E2,$A$2:$D$100,3,FALSE)`