Hi, I am trying to tie two INDIRECT formulas together to make it reference correctly.
I got a formula that can reference another worksheet:
=INDIRECT("'"&A2&"'!A1:A500")
I got a formula that can reference another range:
=INDIRECT("A"&$C2&":"&"A"&$D2)
But I'm unable to get a formula that can reference another worksheet AND Range.
I'm wanting to write a formula that I can dynamically reference another worksheet, column, and Row (range). Please see attached worksheet for my example.
https://www.dropbox.com/home?preview=2015-06-08+INDIRECT+Formula.xlsx
I got a formula that can reference another worksheet:
=INDIRECT("'"&A2&"'!A1:A500")
I got a formula that can reference another range:
=INDIRECT("A"&$C2&":"&"A"&$D2)
But I'm unable to get a formula that can reference another worksheet AND Range.
I'm wanting to write a formula that I can dynamically reference another worksheet, column, and Row (range). Please see attached worksheet for my example.
https://www.dropbox.com/home?preview=2015-06-08+INDIRECT+Formula.xlsx