Forum Discussion
How to use tab name in a cell instead of typing tab name?
On the Summary tab, you could use the following formula as an example:
=INDEX(INDIRECT("'" & A1 & "'!A1"), 1, 1)
=INDIRECT("'" & A1 & "'!A1")
Both the INDIRECT and INDEX/MATCH approaches achieve the same result, allowing you to reference cells dynamically based on the tab name specified in another cell. Choose the one that you find more convenient or suitable for your specific use case.
On the Summary tab, you could use the following formula as an example:
=INDEX(INDIRECT("'" & A1 & "'!A1"), 1, 1)
=INDIRECT("'" & A1 & "'!A1")
Both the INDIRECT and INDEX/MATCH approaches achieve the same result, allowing you to reference cells dynamically based on the tab name specified in another cell. Choose the one that you find more convenient or suitable for your specific use case.
Thank you for help. I appreciate it very much. NikolinoDE
