MartinS
Active Member
- Joined
- Jun 17, 2003
- Messages
- 487
- Office Version
- 365
- Platform
- Windows
Probably an easy one, but the obvious doesn't work.
I have a column of references to an Excel table, where they are being looked up using Index/Match, but the actual header is stored alongside the formula.
Rather than use INDEX/MATCH, is it possible to do something like =INDEX(Table1[$c32], mem_index) where c32 contains the text, say, DoB which is one of the table column headings? It doesn't seem to allow this syntax, but as I have over 600 formula requiring this syntax, I was trying to avoid using so many INDEX/MATCH formulae?
Thanks
Martin
I have a column of references to an Excel table, where they are being looked up using Index/Match, but the actual header is stored alongside the formula.
Rather than use INDEX/MATCH, is it possible to do something like =INDEX(Table1[$c32], mem_index) where c32 contains the text, say, DoB which is one of the table column headings? It doesn't seem to allow this syntax, but as I have over 600 formula requiring this syntax, I was trying to avoid using so many INDEX/MATCH formulae?
Thanks
Martin