Hello Excel Friends,

I have attached a spreadsheet. I need to insert two drop down boxes in to the data. Managed to insert one drop down box. But I am not sure how to insert the second drop down box.

Please help


Excel Dumbo

Here you go. Notes on how to do it are included in the workbook.

S.

Thanks a lot Spencer.

BUt if you notice. There are two drop down boxes . One for the PLAN and the other for the Month. When I select items from the two boxes , the desired items are not showing up.

Please advise.

Your original post didn't say anything about the need to adjust those formulas, so I didn't even look at them.

I think you may have problems with what you're trying to do due to the layout of your data. Merged cells are always a pain in the posterior.

I cannot think off of the top of my head, of an easy way to accomplish this.
But perhaps someone will be along soon to help you out.

If I think of a solution I'll come back and post again.

On Wednesday, August 22, 2012 2:43:37 AM UTC-5, Excel Dumbo wrote:
Hello Excel Friends,



I have attached a spreadsheet. I need to insert two drop down boxes in

to the data. Managed to insert one drop down box. But I am not sure how

to insert the second drop down box.



Please help





Excel Dumbo





+-------------------------------------------------------------------+

|Filename: DATA VALIDATION QUERY.zip |

|Download: http://www.excelbanter.com/attachment.php?attachmentid=550|

+-------------------------------------------------------------------+







--

Excel Dumbo
Use b2:c2 for dv dates
use b1:g1 for dv plan
use this formula in i3 copied down

=OFFSET($A$1,ROW(A2),MATCH($I$2,$2:$2,0)-1+MATCH($I$1,$1:$1,0)-2)