I need formula held in below scenario as month on month the user will add the data as shown.
I am preparing a dashboard so that monthly basis I need to fetch the latest record entered by the user.
seeking your help on this.
Maybe you can try =OFFSET(B4;1;XMATCH(C10;IFERROR(MID(C3:H3;7;9)+0;"");-1);3;3)
or (legacy) =OFFSET(B4;1;MATCH(C10;IFERROR(MID(C3:H3;7;9)+0;"");1);3;3)