Index Match Function with a Date
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.
|