Hi - Dave here.
Last week, I shared a formula that performs a
case-sensitive lookup with VLOOKUP.
This week, I want to share a formula that uses exactly the same trick to make VLOOKUP work with multiple criteria:
[
download the workbook and read the full explanation]
The approach is the same as before: apply logical conditions to the data and create a
new table that VLOOKUP can use to find the correct result.
Note: This is an advanced technique. With XLOOKUP or INDEX and MATCH, the formulas are more straightforward. See links in the article.
More Excel formulas
We maintain a large list of working formulas
here.
If you need more structure, we also offer
video training.
Have a fun and safe weekend!
Dave
