VLook up with several conditions

[lorch]

Hi,

I'm receiving an extract of data and I would like to rearrange in another spreadsheet.

for that I have a to use a Vlookup function with several condition.

Here is the file I receive:

-- removed inline image ---


I want to have the status (contained in the data I receive) in the orange cell. the conditions are the blue cells:number 00041782 with R=A and ID=OWF

I tried this formula bu I get a NA#:
{INDEX(Extract!G:G;(MATCH(1;(A2=Extract!A:A)*(B2=Extract!C:C)*(C2=Extract!D:D);0)))}

I have then to do the same for the start date, end date (the other yellow cells) and change of conditions ID=3DWF but still with R=A and the ID=00041782.

If someone could help me it would be so great.

Thanks a lot in advance