Return Data from Table using Cell Reference

MartinS

Active Member
Joined
Jun 17, 2003
Messages
479
Office Version
  1. 365
Platform
  1. 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
 

Excel Facts

What is the shortcut key for Format Selection?
Ctrl+1 (the number one) will open the Format dialog for whatever is selected.
You can use indirect like
Excel Formula:
=INDEX(INDIRECT("Table1["&$c32&"]"), mem_index)
although indirect is slow & volatile.
 
Upvote 0
Solution
Thanks, I didn't think of it in that format, but appreciate your comment about the speed.
 
Upvote 0
You're welcome & thanks for the feedback.
 
Upvote 0

Forum statistics

Threads
1,212,947
Messages
6,110,837
Members
448,302
Latest member
sniffit1st

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top