In trying do a Switch with a drop-down closing choosing value between to different Tables
Table A and Table B
Simpel question but I can't figure out how to write a address with two strings, "Table A"::"C2" from two other cells.
Guess that's its very simple.
Look, picture
You could use the INDIRECT function referencing the Pop-Up menu in B2 (Switch between tables).
The INDIRECT function in C2 referencing cell B2 (= the Pop-Up menu) will get the content B2 from Table A or Table B:
Paul.
Thanks, that solved the problem.
And a secondary occrued.
As you can se it will be a loot of keyboard handiwork when it is about 6x 50 cells.
Is it a way to do this so you can as usual copy and past the function from one cell to all selected cells in a column?
How to combine two cells "Table B" "C2" to the address Table B::C2
