September 16, 2020

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.

Read More »