Hi,
I've been playing around with the Indirect Function and how it can be used for workbooks with multiple sheets. I've been successful using it for Vlookups but can't get it to work for Index and Match functions.
Here is the Vlookup function that works:
=VLOOKUP(A9204,INDIRECT(D9204&"!A:o"),15,FALSE)
Here is the Index/Match Function I am trying which does not work:
=(INDEX(INDIRECT(D9204&"!A:o"),MATCH(A9204,INDIRECT(D9204&"!A:o"),FALSE),15))
Any help on what I'm doing wrong with the Index/Mathc version would be appreciated.
Thanks,
Jayule
Bookmarks