lost_in_the_sauce
Board Regular
- Joined
- Jan 18, 2021
- Messages
- 128
- Office Version
- 365
- Platform
- Windows
Got help yesterday with INDIRECT so that a formula in cell H6 on tab1 would change which tab is looking for cell T6 based on a drop down list of the tabs - =INDIRECT($F$3&"!T6") - where $F$3 has the drop down list of tab2, tab3, tab4. Works great.
However, I need this formula to populate across a large group of cells, and when I copy/paste formula, the T6 doesn't change which I think is because it's being viewed as a text string and not a formula - but I need it as a text string for the INDIRECT to work? Is there a way to change it so that I can copy/paste the formula?
However, I need this formula to populate across a large group of cells, and when I copy/paste formula, the T6 doesn't change which I think is because it's being viewed as a text string and not a formula - but I need it as a text string for the INDIRECT to work? Is there a way to change it so that I can copy/paste the formula?