Need to pull multiple reference points into one spread sheet

Hello,

I am working on a project that involves pulling information from one sheet onto a master sheet. I have used an indirect formula before in doing this but I have only used 2 "names" in order to get what I wanted. In the spread sheet I have attached there are two drop downs, one for the month and one for the "project" being worked on. I'm not sure how to name a cell and use the indirect function with two drop downs as opposed to just one.

Are there other formulas that I could use to achieve the results desired?

this will give you what you need, buty you will need to changethe references if your range on the data sheets change..

=VLOOKUP(A2,INDIRECT(A1&"!A2:e14"),2,FALSE)

Change the ,2, to 3...4 as needed

*modified based on FDibbins' formula

=VLOOKUP($A2,INDIRECT($A$1&"!A2:e14"),COLUMN(B2),FALSE)

I just had another look at that...

If you name your ranges april/may/june etc, then all you need is...

=VLOOKUP(A2,INDIRECT(A1),2,FALSE)

Sure, i incorporated JieJenn's col() function into my revised formula. My formula is based on having the data for each month as a named range, if you cant do that (if you dont know how, ask me), you will have to manually enter the ranges into the formula, and revisde its structure to what my 1st replky said (plus Jenns contribution)

Couldnt see what you were trying to do, but here is what you want. Please note tho, it depends on a named range being created for each month.

let me know how this works for you, and if you need anything else

Hello oniete1997,

In Master lookup B2 you have full month name in drop down. So always use sheet names in full month like January NOT Jan, feb, Mar etc...

Use the same heading in master C2:X2 just like entered in other sheets

in Master C2 enter this,

=MATCH(C2,INDIRECT("'"&$B2&"'!1:1"),0)

Assume headings are in first row in all sheets

Then copy across.

In C4,

=SUMPRODUCT(SUMIF(INDIRECT("'"&$B$2&"'!A:A"),$B3,INDIRECT("'"&$B$2&"'!"&ADDRESS(1,C$1))))

Then copy across.

oops looks like the attachment didnt take, i will try again....