Use VLOOKUP

Look up a value in the first column of a table and return a matching value from another column.

You will learn to

• Understand lookup value, table, column index
• Always use FALSE for exact matches

How it works

VLOOKUP searches the first column of a table for a value and returns a value from the same row in another column: =VLOOKUP(G1,A2:D6,4,FALSE). The fourth argument FALSE requests an exact match — use it almost always. VLOOKUP cannot look to the left; XLOOKUP can.

=VLOOKUP(G1,A2:D6,4,FALSE)