VLOOKUP searches the first column of a range for your key and returns a value from a column to the right. Always end with FALSE for an exact match.
Do it with AI insteadStart the formula
In the result cell type =VLOOKUP( and select the value you want to look up.
Pick the table range
Select the table where the key is in the first column. Press F4 to lock it with $.
Set the column number
Count from the table's first column to the column you want to return, then enter that number.
Force an exact match
Add , FALSE) to finish. Press Enter.
=VLOOKUP(A2, Sheet2!$A$2:$D$100, 4, FALSE)No — use XLOOKUP or INDEX/MATCH when the return column is left of the key.