For many, the INDEX-XMATCH combination in Excel is the go-to method for retrieving a value from a dataset. However, you can also use this dynamic duo to perform two-way lookups, returning a value at ...

Once you have mastered VLOOKUP in Excel it's time to move on to INDEX/MATCH. This formula combination gives the same results but without the problems of VLOOKUP.

You can use the VLOOKUP function in Microsoft Excel to efficiently find corresponding data for a specific value.

Many people who have used Excel for years still perform lookups using the old-school INDEX-MATCH combo, primarily because it's more flexible than VLOOKUP and XLOOKUP.