vlookup multiple tabs

  • Thread starter Thread starter yhoy
  • Start date Start date
Y

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!
 
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?
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Using text from cell in a range lookup 1
Combining IF Statement and Vlookup 0
Vlookup using a reference to a named range?(Excel 2000) 4
Vlookup equation for multiple tabs 1
Vlookup equation on multiple tabs 7
VLOOKUP error #NAME 2
Vlookup and Trace Return Cell 2
tab name 7

Back
Top