Using Tab Name in a formula

  • Thread starter Thread starter Pec2b
  • Start date Start date
P

Pec2b

I am looking to have a multiple tab spreedsheet ( "Jan" "Feb" "Mar" .
.) and an analysis page where the monthly information is crunched.
use vlook up to import this data. Can I put in A1 "Data for Month:
and then enter the tab name "JAN" and have the vlookup use the data i
that tab for calculation
 
I'd suggest that you put the tab name in B1 and use

=VLOOKUP(A3,INDIRECT("'"&B1&"'!A1:B100"),2,0)

if you need to use A1 together with other text strings

=VLOOKUP(A3,INDIRECT("'"&RIGHT(TRIM(A1),3)&"'!A1:B100"),2,0)

in both example A3 holds the lookup value
 
WOW! I posted this like an hour ago and this solution works perfectly!
You guys, girls & this forum ROCK! :
 
Back
Top