INDEX MATCH with dates in a ROW

Thanks for the quick reply, this is driving me crazy!

In my sample, you see to the far right of the first table (the one I want to pull the data into) the words
"Week 1". For each month, there will be 4 tables like this on the same worksheet, 2 side by side, Week 1 & Week 2, then below that Week 3 & Week 4, all with the dates in the month. I'm looking to find the column that has the corresponding date, i.e 3/28/11 as well as the selections chosen from the combo boxes (those won't change with the exception of adding or changing months) and bring the data from the data table from the row, i.e. "Total Ordered" into the "Total Ordered" column in my display table.
It is just one table that I am pulling from for now. I may need to clean it up and put the data by month into separate tabs, but I think that, if I can get the simple part of it working, I should be able to handle any changes like that in the future.
I've updated my example to include an additional week, I hope this helps. Again, thank you for your help.

The month combo box needs to match up the month in this case in "A7" and "M7" with the month in the data table showing in B16. The combo boxes will change all 4 display tables to the month selected. Since I will have multiple months and divisions, there will be a table for each division for a given month, so, in this case, a table for Cars, Boats and Bikes one underneath the other. I could, if it makes it easier, just use one table and add columns to repeat the division and month all the way down. Then another table for the next month's data. Since I will only be showing about 4 months at a time and dropping off previous months, it shouldn't get too ugly.

Sorry it's so confusing, I really appreciate you're sticking with me! As I showed in my 2nd attachment, A7 and M7 will both show May in addition to 2 other sections because there is one table on the same worksheet for each Week-Week1, Week2, Week3 and Week4. I have the combo boxes set to change both the Division and the Month on all 4 of those sections.

I have changed my data table structure in hopes that it will be a little easier, please see attachment.

I have the two combo boxes indexed(??) to match another cell as follows - Month selected=May, index is 5/1/2011, Division selected=Cars, index is 20.

Thank you!!!

Wow, that's crazy! thanks so much! It's awesome to see it actually work, I'll be spending some time trying to understand the individual formulas. So if.. I wanted to make it work with my data structured in my 2nd attachment, I should just be able to alter this to pull from columns instead of the rows?

My data is going to be in the table format in the 2nd attachment. Cars/March categories in my data are referenced by
Division-10-Cars
20-Boats,
30-Bikes.
The 10,20,30 reference the field "Division" in my data table.
March, April, May etc. reference the field "Month" in my data table. I have my combo boxes, when selected, enter those keys (20 and 03/01/2011) in 2 cells on my worksheet and use those in my lookup function. This is how I read somewhere online how to approach this-not sure if it's correct or the best way. So, I need to reference 3 columns in my data table, Month, Division and Day. Getting closer! Your lookup from yesterday works perfectly and I now need to do another project with the data in this new column format. I am learning a lot from this experience, watching a lot of videos! I appreciate all of your help. If there is any good site you could point me to that you think is good, please let me know. You can get lost in all of the google searches.

Wow, that worked perfectly and I even understand it! Thank you so much,excited to continue with my project using this! Do you have any recommendations for books on Excel 2007 formulas like this?