Do you think that it makes sense to use two MATCH functions inside an INDEX function? It certainly does. This combination allows us to create a nested function that has lookup values in rows and columns at the same time.
INDEX is a function that needs two inputs – a row number and a column number. And we can use one MATCH function to provide us with a row number, and a second MATCH function to provide us with a column number. Sounds logical, doesn’t it?
Some other related topics you might be interested to explore are VLOOKUP, HLOOKUP, and INDEX&MATCH.
This is an open-access Excel template in XLSX format that will be useful for anyone who wants to work as a Financial Analyst, Business Analyst, and for everyone who works with a spreadsheet software.
You can now download the Excel template for free.