vlookup multiple tabs

[yhoy]

I have multiple tabs with same format. Is it possible to set up the vlookup
with tab name as an input?

example tab names: US1, US2, CA1

Thanks!

 

[JBeaucaire]

Possible, yes, the INDIRECT function would probably be the best
approach. But a LOT of INDIRECT functions can affect sheet performance.
How many did you have in mind?

Also, you give no examples or post no workbook sample so we can see HOW
you would want these VLOOKUPs with corresponding sheetnames to work?
What info are you pulling from one sheet to the next? What criteria? How
will the sheetname be of assistance.

Also, saying that US1 and US2 are the same format, I agree. But adding
CA1 as the next example and I say they are no longer the same. That's
just me.

 

[yhoy]

Partially worked it out by posting on the forum.

=INDIRECT("'"&A3&"'!$D$26")

Cell A3 has the tab name I referred to earlier "US1 / US2/ CA1"

Now instead of a definite cell (D26 as in formula), I want to refer to
another cell (B3) for the location. Do I need another indirect to make it
work?

 

[yhoy]

Issue resolved in this posting:
http://www.microsoft.com/communitie...&p=1&tid=244e1b11-23e1-42d0-a393-d36569bbf735

Thanks!

 

[JBeaucaire]

Partially worked it out by posting on the forum

=INDIRECT("'"&A3&"'!$D$26"

Cell A3 has the tab name I referred to earlier "US1 / US2/ CA1

Now instead of a definite cell (D26 as in formula), I want to refer t
another cell (B3) for the location. Do I need another indirect to mak
i
work

Yes, if B3 had a cell reference in it, you could slip it in the sam
way

=INDIRECT("'"&A3&"'!"&B3