Formula for variable date ranges in IF(LOGICAL TEST)

[dan_apple]

Previous correspondence about this post is found at https://www.excelforum.com/excel-fo...te-ranges-in-if-logical-test.html#post5168556
--------------------------------------------

I am trying to make a formula that works something like;

=IF([LOGICAL TEST]Date x<=Date y BUT Date x>Date z, [IF TRUE]Cell A which is associated with Date x, [IF FALSE]in the LOGICAL TEST part, +1 row down for Date y and +1 row down for Date z until Date x falls between Day y and z. Then use the Cell associated with that Date x)

Attached is an example of what the result should be which may best explain my issue

Thanks
D

Book1.xlsx‎

 

[Fluff]

Duplicate https://www.mrexcel.com/forum/excel-questions/1105812-value-associated-date-range.html

Please do not post the same question multiple times. All clarifications, follow-ups, and bumps should be posted back to the original thread.
Per forum rules, posts of a duplicate nature will be locked or deleted (rule 12 here: Forum Rules).