How to reference tab names in formulas for tables.

So we write a lot of excel sheets for pulling together monthly summaries of individual days, and i was wondering if there was someway to just reference the names of the tabs in a table, say if its ju...

excel

mtarler
Feb 09, 2023
You have to use the function INDIRECT(B5 & "!$G:$G") but INDIRECT is a 'volatile' function meaning it will have to get re-calculated all the time and may have performance hits on excel

mtarler

Silver Contributor

Feb 09, 2023

You have to use the function INDIRECT(B5 & "!$G:$G") but INDIRECT is a 'volatile' function meaning it will have to get re-calculated all the time and may have performance hits on excel

DAS85
Copper Contributor
Feb 09, 2023
That did it, you were just missing a Quotation mark after G, but thank you very much. This was absolutely killing me.
- mtarler
  Silver Contributor
  Feb 09, 2023
  you're welcome and good catch and fixed

Forum Discussion

How to reference tab names in formulas for tables.

Resources