i have this work sheet where b 3 is date 1-4-24 m4 to 04 has dates 1-4-23 to 1-4-25 m 5 to m7 have amounts simliarly n5 to n7 and o5 to 07. i want a formula when b 4 matches any of the date in m4 to 04 then the value under the respective column should be shown in d 5 to d7.IFERROR(INDEX($M$5:$O$7, ROW(D5)-ROW($D$5)+1, MATCH(YEAR($B$3), $M$4:$O$4, 0)), "Year Not Found") I tried this formula but it is not working .i tried downloading xl2bb but when i tried to open it get message not able to open in protection mode