SOLVED

How to use tab name in a cell instead of typing tab name?

Copper Contributor

Often, we use something like =Current!A1 to retrieve data from tab name Current and print on Summary tab.   How can we use "Current" from Cell?  Thanks.

2 Replies
best response confirmed by Hans Vogelaar (MVP)
Solution

@smmvols84 

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 

1 best response

Accepted Solutions
best response confirmed by Hans Vogelaar (MVP)
Solution

@smmvols84 

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.

View solution in original post