Select the cell where you want the result to appear
Type `=VLOOKUP(`
Enter the lookup value
Type a comma
Select the table array or range to search in
Type a comma
Enter the column number to return the value from
Type a comma
Enter `FALSE` for an exact match or `TRUE` for an approximate match
Close the formula with `)`
Press Enter
Use `FALSE` when matching names, IDs, or exact values
Use `TRUE` only when the first column is sorted and approximate matching is needed
Make sure the lookup value is in the first column of the selected range
Make sure the column number counts from the leftmost column of the selected range
Use absolute references like `$A$2:$D$20` when copying the formula
Handle errors with `IFERROR` if needed