populating rows based on dates

shamsu203

Board Regular
Joined
Jun 12, 2014
Messages
90
Office Version
  1. 365
Platform
  1. Windows
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
 

Attachments

  • Screenshot (42).png
    Screenshot (42).png
    247.7 KB · Views: 20
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...

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.
 
Upvote 0

Forum statistics

Threads
1,226,771
Messages
6,192,919
Members
453,767
Latest member
922aloose

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top