Returning cell value in case today is between two dates

[dLhx]

Hello everyone,

Please see attached document to get a better idea of what i would like to extract.

- Today() is in cell B17
- Cells B4 to B8 are in B18 to B22
- in the C18:C22 range i would like to have the values from 2-Apr-17 from the B3:N8 table

So, in case today is between cell C3 and D3 to return the content for C3 for each entry from B18:B22 in C18:C22

Thanks,
-Alex

[avk]

Try with

Please Login or Register  to view this content.

This is if "B17" (Today) in between "C3" & "D3" then Data from "C4" to "C8" extract at cell "C18" to "C22"

[FDibbins]

Try this, copied down...
=INDEX(C4:N4,MATCH($B$17,$C$3:$N$3))

[dLhx]

@FDibbins: the formula work but the problem is that i have more "Stuff" and more dates above .. can the formula be modified to search also for the "Stuff" ?

[FDibbins]

Try this...
=INDEX($C$4:$N$8,MATCH($B18,$B$4:$B$8,0),MATCH($B$17,$C$3:$N$3))

[dLhx]

@FDibbins: TY, this works perfectly!

[FDibbins]

Happy to help and thanks for the feedback