Microsoft Excel - No one seems to know, especially me

I have data in two columns.  In column A:A I have years and in column B:B I ahve months.  Lets say on another sheet someone select the year 2001 from a dropdown and in another dropdown the month August.  So we have 2011 and August.  I need a macro to look in A:A for the year and find the month August and her is the key, return or tell me the row.  Below is and example. I need to find row3 with a macro.

      Column A;A  Column B:B
row1  2010        July
row2  2011        May
row3  2011        August
row4  2011        March

If you put this in as an array formula, it will return the row:

{=MATCH(D1&E1,A:A&B:B,0)}

Note, type in:

=MATCH(D1&E1,A:A&B:B,0)

and press ctrl-shift-enter to make it an array.

Hi Dan,

Note, in my test data I had the table in A&B, with the lookup values in D1 & E1.

I figured it out, Just had to reaarange some.

Thank you for your help, I appreciated it.

Dan