good afternoon,

i need to find a formulae to lookup something on a tab, where the tab name
can be different, based on various alternatives.

i have used the formulae
MID(CELL("FILENAME",A1),FIND("]",CELL("FILENAME",A1))+1,32) before, but i
cannot find any information on how to use this.

is there a website where i can find information on referencing vlookup
commands on different tabs based on the value of a cell?

thank you,