How can I use the drop down cell selection in a formula?

R

Red Dianthus

I have created a dropdown box which allows me to choose from the list
of tabs -- each tab represents a month. I want to use that drop down
selection in a vlookup....=MAX(IF('Aug 2009'!G45:G143=G9,'Aug 2009'!
B45:B143,FALSE)) How can I replace the 'Aug 2009' so that the formula
uses the month/tab selected from the dropdown menu?

Thanks!
 
S

Shane Devenshire

Hi,

Try something like this

=MAX(IF(INDIRECT("'"&F7&" 2009'!G45:G143")=G9,INDIRECT("'"&F7&"
2009'!B45:B143"),""))

where F7 contains your drop down list of sheet names as 3 digit text. This
is an array formula which means you must enter it by pressing
Shift+Ctrl+Enter, not Enter.

If the sheet names include the year then use

=MAX(IF(INDIRECT("'"&F7&" 2009'!G45:G143")=G9,INDIRECT("'"&F7&"
2009'!B45:B143"),""))
 

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

Drop down list control value in vba 2
Drop Down List Dependant Formula 2
Drop down list from index/match formula 1
Drop Down Selection Assistance 2
A formula that grabs info from a specific tab 5
Incrementing a cell selection 3
Help with drop down selection and populating related data... 9
how to add a combolist drop down to each row 2

Top