Lightning Lessons
VLOOKUP is Dead, Long Live FILTER
All the limitations of VLOOKUP, INDEX-MATCH or even XLOOKUP can be solved by using FILTER and SORT instead. Read on to find out how to do a “VLOOKUP” with multiple criteria and how to handle multiple matches.
