Hi,
Im using a formula to identify new part numbers.
The formula is: =IF(ISNUMBER(MATCH(A217,Existing!A:A,0)),"","NEW")
However you can clearly see from the attached that if has flagged a duplicate part number as new. Why would it do that? Check out A1368 in existing and A217 in new
Please help.
Thanks
Bookmarks