Every time we find something worth sharing we will post an article on it here.

Lightning Lessons
Simon Maller

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 »