FUNCTION CATALOGUE / LOOKUP & REFERENCE
VLOOKUP Excel function
Looks up a value in the first column of a table.
Correct sentence to use
Find [lookup value] in the first column of [table] and return column [index].
Modify this query in PlainFormula →Example formula
=VLOOKUP(E2,A:D,3,FALSE)
Looks vertically in the first table column.
Syntax
VLOOKUP(lookup_value, table_array, col_index_num, [range_lookup])
Argument signature: lookup_value, table_array, col_index_num, [range_lookup]
Availability note
Commonly available in current Excel; verify platform and locale-specific behaviour.