Macro to Identify column wise data based on multiple user defined criteria on a different sheet

[patsdavixen]

Hi,

I have 3 worksheets in a workbook. The first sheet is the "Input" Sheet, the second sheet is the "Calculation" sheet and the third is "Data" sheet. The user can select 3 criteria on the input sheet from predetermined drop downs. The first drop down is the service year – Year 1,2,3 only. the second drop down is the month "Jan,Feb,etc" and the third drop down is the year "2012,2013 or 2014".
Based on the selection of the drop downs on the "Input" sheet, the macro should go to the “Data” sheet and search for criteria 1 that is the service year which is repeated 4 times in row 1, it should then search for criteria 3 which is the year which is again repeated 4 times in row 2 of the "Data" tab. It should then search for the month under criteria 1 & 3 which is the month in row 3.
Could someone let me know if I’m supposed to use an Index Match formula or is there another way of identifying a column in a worksheet based on 3 criteria on another worksheet.

Any help would be appreciated.

Thanks – Pat