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)