SOLVED

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

Copper Contributor

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

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

# Re: 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.

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

Thank you for help.  I appreciate it very much.  @NikolinoDE

1 best response

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

# Re: 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.