Partial Match, display true or false

Closed
BC - Oct 22, 2010 at 12:54 PM
venkat1926 Posts 1863 Registration date Sunday June 14, 2009 Status Contributor Last seen August 7, 2021 - Oct 22, 2010 at 10:29 PM
Hello,

I have a list of serial numbers that have the same part number in the middle of the serial number. The part number is always the same and I want confirm each serial number I scan confirms the part number is in the number scanned. Additionally, I would like to be able to include multiple part numbers because I may have up to 5 I am looking for on the same worksheet. If none of the 5 part numbers are not listed in the serial number then False would display.

PS, the part number is 4 digits long

Related:

1 response

venkat1926 Posts 1863 Registration date Sunday June 14, 2009 Status Contributor Last seen August 7, 2021 811
Oct 22, 2010 at 10:29 PM
give two or three examples. in which sheet and in which column the part numbers are typed?
0