Require a formula to list requests against dates

[john dalton]

Hi,

I need a formula to list requests against the relevent dates, I have tried just about everything and can't seem to get the right result.

Please see the attached sheet for details.

Thanks in advance

JD

[Ace_XL]

Hi John.. try this

In H3
=INDEX($D$3:$D$6,MATCH(1,INDEX(($A$3:$A$6=K$2)*($B$3:$B$6<=G3)*($C$3:$C$6>=G3),0),0))

Copy down and across to Column N too

[john dalton]

Hi ACE-Xl great solution, works brilliantly.

Cheers

JD