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!
XLOOKUP – Excel Function
What it does: The XLOOKUP() Function allows you to look up and return values in corresponding columns or rows (!!). I have an
Top 5 Things to Know in Excel
I remember listing “Microsoft Excel” as a skill on my resume just out of college. The only functions I knew how
06
Oct
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
INDEX – Excel Function
What it does: THE INDEX() Function returns a value based on the array of values you select and the row and column within that