G
Guest
Hi Team,
I have multiple tabs each with similar but different 2X2 reference data on
them.
On my user input sheet I want the user to input data that then calculates
which tab the rest of the formula should perform the index/vlookup/hlookup
on. I know about =&[Tab] function in the header/footer but can I do a
=[$C$2]! where $C$2 changes?
Thanks
Ditch
I have multiple tabs each with similar but different 2X2 reference data on
them.
On my user input sheet I want the user to input data that then calculates
which tab the rest of the formula should perform the index/vlookup/hlookup
on. I know about =&[Tab] function in the header/footer but can I do a
=[$C$2]! where $C$2 changes?
Thanks
Ditch