using formula to pull data from different worksheets

S

smann

I am attempting to pull in data from different tabs in my workbook based on
specific month chosen by the user, which is done from a combo box. For
example, if user chooses March, I need to pull in data from a tab labeled
IM_March. I have the month chosen stored in a specific cell so I tried using
a vlookup using the & function ("IM_&e2") with e2 being the stored cell, but
that didn't work....anyone can give me some direction. Thanks
 
J

JCS

Hi,

Not knowing what your ranges in your other sheets are, the following is an
example that you can adapt for your need:

=VLOOKUP(a1,INDIRECT(CONCATENATE(e2,"!","A1:B6")),2
OR
=VLOOKUP(a1,INDIRECT(e2&"!"&"A1:B6"),2)

If this helps, please press YES

John
 
J

JCS

Hi,

For the first example i left a parenthesis at the end of the formula out by
mistake. It should read:

=VLOOKUP(a1,INDIRECT(CONCATENATE(e2,"!","A1:B6")),2)

John
 
C

CLR

=INDIRECT("IM_"&E2&"!a1")
with "March" in Ee of the activesheet, this formula will return the value
from A1 on the sheet "IM_March"

Vaya con Dios,
Chuck, CABGx3
 
S

smann

Thanks, this helped....

CLR said:
=INDIRECT("IM_"&E2&"!a1")
with "March" in Ee of the activesheet, this formula will return the value
from A1 on the sheet "IM_March"

Vaya con Dios,
Chuck, CABGx3
 

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

Top