An curved arrow pointing right. Once you have mastered VLOOKUP in Excel it's time to move on to INDEX/MATCH. This formula combination gives the same results but without the problems of VLOOKUP.

This guide explores key Excel functions—FILTER, XLOOKUP, SUMIFS, INDEX-MATCH, and VLOOKUP—detailing their ... FILTER to performing advanced multi-criteria lookups with INDEX-MATCH, you ...

I will use VLOOKUP, because I want Excel to look up the values in the ... I would use COUNTIFS, as I have two criteria.