## 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.

## 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

## 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

## 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

## MATCH – Excel Function

What it Does – Locate the position (often the row number) of an item in an array. Arguments: MATCH(lookup_value,