Standard VLOOKUP only supports one lookup value. To use multiple criteria, you must either combine your keys into a unique identifier or upgrade to the XLOOKUP function.
Mit KI erledigenCreate a helper column
Insert a new column to the left of your data and use the ampersand (&) to concatenate your criteria columns (e.g., =A2&B2).
Concatenate lookup values
In your formula, combine your multiple lookup values in the same order used in the helper column.
Execute the VLOOKUP
Reference the concatenated lookup value against the helper column range to retrieve your desired data.
=VLOOKUP(criteria1&criteria2, CHOOSE({1,2}, col1&col2, result_col), 2, 0)VLOOKUP is designed to search for a single value in the first column of a range; it cannot natively evaluate multiple columns simultaneously.