VLOOKUP

The VLOOKUP function below searches for the value 53 (first argument) in the leftmost column of the red table (second argument). The value 4 (third argument) tells the VLOOKUP function to return the value from the fourth column of the red table in the same row.