I hope someone can help with a problem that is driving me soft? I want to enter a 15 digit part number into a cell and compare it to up to 5 different 15 digit part numbers (on the same sheet) and return a yes or no in an adjacent cell if there is a match or not to these 5. My problem is that ocaisionally an extra random digit or letter is put on the end of the part number. Could anyone suggest a formula for me please? I have being trying IF THEN statements but have had no luck. Thanks in advance,
Poco
Poco