Edit - TMS also covered the false as i was typing
Thanks for quick reply. The ampersand is just to indicate that it has a PO and it has been quoted and priced
OK,
BUT you do have the same AND() further in the Nested IF as pointed out by me and TMS , also the missing ""
and a final FALSE condition after the DUPLICATED , so you would get FALSE in the cell if no matches at all