Forum Discussion
Solved
convert cell value into name either to call a tab or a named array
To fill up a table, I need to gather values from multiple tabs; for each row a different tab. I added the exact names of the tabs in the first column. Then I tried =A10!B14 to get the value in the ...
I just removed the quotes to read directly the cell value as a reference. It worked 🙂
=INDEX(INDIRECT(A35);MATCH($J$33;Inputs;0);MATCH(B$33;Quarter;0))
Unless I am mistaken, I guess we're done on this. Thanks folks!
Dip_Bou You can do this using the INDIRECT function, but I recommend that you first reconsider your design. The way your data is spread across more than one worksheet makes your Excel work unnecessarily complicated. If all were on a single tab in a single table, it would be very easy to summarize your data.
The INDIRECT formula would look like this (the single quotes are needed because sheet names might contain spaces):
=INDIRECT("'"&A10&"'!B14")