populating rows based on dates

[shamsu203]

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

 

[zero269]

i tried downloading xl2bb but when i tried to open it get message not able to open in protection mode

Are you opening the file in Protected View delibertly, or is this a file being opened on your computer from an unprotected folder location?
Check out Microsofts aricle here if needed: What is Protected View? - Microsoft Support

On another note, did you get a chance to look at the alternate installation and configuration options here...

XL2BB - Excel Range to BBCode

Excel 'mini-sheet' in messages - XL2BB Although experts prefer to read your description and question instead of working in your actual file to solve your problem, there are times that it is difficult to explain an issue without providing actual...

www.mrexcel.com

If your file is being opened fom an unprotected location...

• Either simply move/copy the file to one of your already Trusted Locations
• Or you can add the location to your Trusted Locations

To add a new location, simply...

• Copy the folder path where the file resides, then in Excel, go to:
• File > Options > Trust Center > Trust Center Settings... > Trusted Locations
• Add the folder using the Add new location button and Paste the folder path into the Path field.

If you're opening the file from an email attachment, save the attachment to one of your Trusted Locations on your computer.

This will make getting support in this forum that much easier for you and others willing to help.