if and vlookup help

[Isacael]

Hi All

I am trying to write an IF statement with essentially two conditions requiring lookups. Pleae see sample attached. I hope the explanation on the example spreadsheet makes sense.

Cheers

[quekbc]

There are multiple of the same records in column D. Which record would you want the records in A to relate to?