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.
Exemple : =VLOOKUP(A2,PriceList!$A$2:$C$100,3,0)
Référence des fonctions
Fonctions Excel
Consultez 5 fonctions Excel avec leur syntaxe, des exemples et une feuille interactive.
HLOOKUP(lookup_value, table_array, row_index_num, [range_lookup])Same, but searches the first row.
Exemple : =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.
Exemple : =XLOOKUP(A2,B:B,C:C,"none")
MATCH(lookup_value, lookup_array, [match_type])Position within a range. 0 means exact match.
Exemple : =MATCH(A2,B2:B100,0)
INDEX(array, row_num, [column_num])Value at the intersection of a row and a column.
Exemple : =INDEX(C2:C100,MATCH(A2,B2:B100,0))