Edit - TMS also covered the false as i was typing
OK,Thanks for quick reply. The ampersand is just to indicate that it has a PO and it has been quoted and priced
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
Bookmarks