Excel INDIRECT function with INDEX MATCH
Worked example on how to use Excel INDIRECT INDEX MATCH combined, including syntax for INDIRECT and INDEX MATCH.
Worked example on how to use Excel INDIRECT INDEX MATCH combined, including syntax for INDIRECT and INDEX MATCH.
How to use Excel’s INDIRECT function to refer to cells using the values entered into another cell. We show the basic method of how it works, and a more advanced example to refer to content in other worksheets.