What is VLOOKUP?
Vertical Lookup - searches for a value in the leftmost column of a table and returns a value in the same row from a specified column. The most widely-used lookup function in Excel.
Syntax
=VLOOKUP(lookup_value, table_array, col_index_num, [range_lookup])
Example
Formula: =VLOOKUP(\
Result: $1.50
How It Works
Searches for 'Apple' in column A and returns the corresponding value from column C (3rd column). FALSE ensures exact match. VLOOKUP can only look to the right, which is why many users prefer XLOOKUP or INDEX/MATCH.