Select the cell where you want the result to appear
Type `=VLOOKUP(`
Enter the lookup value
Enter the table array containing the data range
Enter the column index number to return the value from
Enter `FALSE` for an exact match or `TRUE` for an approximate match
Close the formula with `)`
Press Enter
Copy the formula down if needed
Ensure the lookup column is the first column in the selected range
Use absolute references with `$` if you want to lock the table range