XLOOKUP vs. INDEX & MATCH
The Vlookup vs. Index Match debate has been going on for a while. Vlookup is easier to grasp and often all you really need.
15
Apr
How to Compare Lists in Excel (Video)
In this video we share two methods for comparing two lists: 1. ISNUMBER+MATCH 2. VLOOKUP Both can be effective, but
How to Use Index & Match (Video)
INDEX & MATCH can be used together as a very powerful combination of functions. This combination is often used in place
How to Use Vlookup (Video)
Vlookup is a very useful function for looking up data from a table, comparing two lists, matching data sets, and much more!
How to use INDEX and MATCH together
I’d probably list INDEX-MATCH in the top 5 things to know in excel if you want to add the skill to your resume and not
06
Oct