Vintage79
Board Regular
- Joined
- May 29, 2007
- Messages
- 185
- Office Version
- 2019
- Platform
- Windows
Hello!
I have several data tables that are named tblRT, tblSC, tblPF etc. I then have a sheet where a user can enter the 2-digit table identifier (RT, SC, PF etc) and I would like to use this information in a formula.
I am using this formula, which works fine: =INDEX(tbl SC ,MATCH(F5,tbl SC [SC],0),2) but I w ould like the 'SC' to be collected from the cell that the user has put it in.
In other words, the text 'SC' is in cell A1, and I want to add this into the formula, so that it will look like this:
=INDEX(tbl&"text from A1",MATCH(F5,tbl&"text from A1"["text from A1"],0),2)
I'd appreciate it if anyone knows how to do this. Otherwise, I may have to examine it from another angle.
Thanks!"
I have several data tables that are named tblRT, tblSC, tblPF etc. I then have a sheet where a user can enter the 2-digit table identifier (RT, SC, PF etc) and I would like to use this information in a formula.
I am using this formula, which works fine: =INDEX(tbl SC ,MATCH(F5,tbl SC [SC],0),2) but I w ould like the 'SC' to be collected from the cell that the user has put it in.
In other words, the text 'SC' is in cell A1, and I want to add this into the formula, so that it will look like this:
=INDEX(tbl&"text from A1",MATCH(F5,tbl&"text from A1"["text from A1"],0),2)
I'd appreciate it if anyone knows how to do this. Otherwise, I may have to examine it from another angle.
Thanks!"