That trick is Index/Match, a function that can find any value in any spreadsheet. One of the most common uses of Excel is as a database ... To beat that, we're going to use INDEX/MATCH.

When you dive into the world of Excel, you quickly realize ... large dataset and you need to find a specific value based on multiple criteria. By using INDEX & MATCH, you can easily locate the ...

Originally, Excel ... INDEX with MAX formula to get the highest number of pirates, but he also needs to know which ship is carrying them. So he uses the INDEX/MATCH with MAX formula to find ...