VLOOKUP(lookup_value, table_array, col_index_num, [range_lookup])Looks in the first column and returns a value from a column to the right.
Esempio: =VLOOKUP(A2,PriceList!$A$2:$C$100,3,0)
Riferimento
Funzioni di Excel
5 funzioni con sintassi, esempi verificati ed errori comuni.
HLOOKUP(lookup_value, table_array, row_index_num, [range_lookup])Same, but searches the first row.
Esempio: =HLOOKUP("March",A1:M5,3,0)
XLOOKUP(lookup_value, lookup_array, return_array, [if_not_found], [match_mode], [search_mode])Modern lookup in any direction.
Esempio: =XLOOKUP(A2,B:B,C:C,"none")
MATCH(lookup_value, lookup_array, [match_type])Position within a range. 0 means exact match.
Esempio: =MATCH(A2,B2:B100,0)
INDEX(array, row_num, [column_num])Value at the intersection of a row and a column.
Esempio: =INDEX(C2:C100,MATCH(A2,B2:B100,0))