vlookup to a specific sheet by drop down box

[leem]

I'm in need of your expert help again. I think I want a vlookup but I could be wrong. I can make 1 vlookup work but I can not get to the right sheet by selecting the sheet from the drop box.

1 drop box linked to cell C1 (sheet names - Jan, Feb, Mar, etc.)
1 drop box linked to cell D1 (same on each sheet - Location A, Location B, Location C, etc.)

I tried "=VLOOKUP(D1,C1,2,0)" but that failed.

"=VLOOKUP(D1,Jan!B:J,2,0)" - this works by telling it what sheet to look at but I need to chose what month (sheet) from the drop down box.

Can you show me the correct formula or a better one?
Thanks in advance for your help and knowledge.

Michelle

[FDibbins]

When you refer to a sheet name or cell ref, you need to use INDIRECT(), so would you use something like...

=vlookup(D1,INDIRECT(C1&D1),2,0)

However, I have a feeling that INDEX/MATCH or using MATCH inside your vlookup may be what you need. I suggest you upload a small (clean) sample workbook (not a pic) of what you are working with, and what your expected outcome would look like.

[leem]

FDibbins
Thank you for taking a look at this. I have attached a sample.
Thanks
Michelle

[FDibbins]

That makes it much easier to understand, thanks

Try this, copied down...
=INDEX(Jan!$C$2:$K$12,MATCH(Master!$D$1,INDIRECT($C$1&"!$B$2:$B$12"),0),MATCH(Master!$B2,INDIRECT($C$1&"!$c$1:$k$1"),0))

[leem]

Thank you. I put the formula in and the numbers change based on the location in Column D1 but if I select Feb it still only brings in the Jan numbers. I don't think I made that clear..sorry. I need it to look up the correct month tab and the correct location on that month tab.

[FDibbins]

No, you were very clear, I forgot to work on the very 1st reference, my apologies...
=INDEX(INDIRECT($C$1&"!$c$2:$k$12"),MATCH(Master!$D$1,INDIRECT($C$1&"!$B$2:$B$12"),0),MATCH(Master!$B2,INDIRECT($C$1&"!$c$1:$k$1"),0))

[leem]

That is perfect! Thank you so much and thank you for sharing your knowledge.

[FDibbins]

Happy to help, thanks for the feedback