View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
dhstein dhstein is offline
external usenet poster
 
Posts: 266
Default look up value on tab name?

If you use that formula in a cell, you will get the name of your worksheet.
Assume that is in cell Z1, you can then reference that with something like
INDIRECT (Z1&"!Q1") This will return the value in cell Q1 of this
worksheet. You can build addresses like that to create ranges or whatever
you need. I'm not sure if that's your question.

"jatman" wrote:

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,