=IF(ISNA(MATCH(1,(A1:A20="IR00202PH")*(B1:B20="S")*(C1:C20="FIXED"),0)),
VLOOKUP("IR00202PH",A:E,5,FALSE),
INDEX(D:D,MATCH(1,(A1:A20="IR00202PH")*(B1:B20="S")*(C1:C20="FIXED"),0)))
which is an array formula, it should be committed with Ctrl-Shift-Enter, not
just Enter.
Excel will automatically enclose the formula in braces (curly brackets), do
not try to do this manually.
When editing the formula, it must again be array-entered.
Note that you cannot use a whole column in array formulae (prior to excel
2007), but must use an explicit range.
--
---
HTH
Bob
(there's no email, no snail mail, but somewhere should be gmail in my addy)