I have columns on one worksheet (Sheet1!E37:F42) that has one row with blank cells. (row 41) I have a table on another sheet (Sheet2!a35:N47) with the top row having the months in columns 3 thru 14 and two rows that has blank cells (rows 36 and 46). I would like to get the month in row 35 of sheet number two that corresponds with the value in the rest of the table in sheet2 that matches the criteria in columns E and F in sheet1. I need a formula that I can copy and paste down as I will be expanding the data base. I have tried every combination of Index/Match that I knew how to do plus all the examples I could find on the internet. Some would work for one row only but them give me a #Ref or #N/A error on the rest.
Thanks for any help in advance for all on the best Excel help website.
Thanks for any help in advance for all on the best Excel help website.