Index Match Multiple Conditions

[GB]

Hi,
I have read various posts on this problem but haven't found a solution so I am requesting your help please.

I have 4 columns of data in one worksheet (Sheet1)
Col A = ID
Col B = Date From
Col C = Date To
Col D = Workgroup

I another worksheet (Sheet2) I have
Col A = ID
Col B = Date
Col C = a formula to the problem I am trying to resolve.

I want to return the "Workgroup" from Sheet1 into Sheet2 if all the following conditions are true:
ID = ID
Date >= Date From
Date <= Date To

I have tried the following formula array entered without success
{=INDEX(Sheet2!$D$2:$D$889,MATCH(A2=Sheet2!A:A,0)&MATCH(B2,Sheet2!B:B,-1)&MATCH(B2,Sheet2!C:C,1))}

Any assistance would be grateful.
regards
GB

 

[NARAYANK991]

Hi ,

See if this is OK.

Narayan

 

[GB]

Hi Narayan,
the formula is perfect and simple to understand.
Most appreciated.
cheers
GB