Hi,
I know there is a HLookup & VLookup function (which i am not very famialir with) but I wondered if there was a way of looking up the name of a tab. For example:
If the tab name is UK then Sum A47 on that sheet.
Thank you in advance for your help - I'm sure this is possible as everything else seems to be on excel, its just knowing how...
I know there is a HLookup & VLookup function (which i am not very famialir with) but I wondered if there was a way of looking up the name of a tab. For example:
If the tab name is UK then Sum A47 on that sheet.
Thank you in advance for your help - I'm sure this is possible as everything else seems to be on excel, its just knowing how...