Excel magic 7 - indirect function

[bayofpigs]

In this video, how would one use the indirect function to look up across multiple tables to get a specific value? I have been using the index/match functions but I find my formulas becoming too large.

Thanks for your help in advance for any suggestions.

 

[Robert Mika]

Hi bayofpigs and welcome to the board.

An example of INDEX/MATCH/INDIRECT
http://www.excelforum.com/excel-wor...index-match-vlookup-loop-across-3-sheets.html

 

[bayofpigs]

Thanks for your timely response