Index Match Function with a Date

[Priyantha Gamini]

Dear All,

I use the IndexMatch function to get data from an excel sheet ("Data"). According to my workbook, I hope to get data to the "B5" Cell in the "Calculation" Sheet matching "B1" & "B3" Cell values from the "Data" Sheet. I try to get only Year & Month from B3 Cell to match with column "A" in the "Data" Sheet. I use the below formula but not working correctly.



=INDEX(Data!$D:$D,MATCH(1,INDEX((B1=Data!$B:$B)*(B 3=Data!$A:$A),0,1),0))

can anyone help me?

Thanks

Priyantha.