How to use the LOOKUP function in Excel to search in a single row or column and find a value from the same position in a second row or column.
VLOOKUP looks for the lookup value in the leftmost column of the lookup table or table array, aiming to find the matching value. That means whatever you want to return must be located somewhere to the right of the column you’re searching in.
Learn all about Excel's lookup & reference functions, such as VLOOKUP, HLOOKUP, MATCH, INDEX and CHOOSE.