zarealshook
New Member
- Joined
- May 26, 2014
- Messages
- 14
- Office Version
- 2016
- Platform
- Windows
Hello Everyone,
Could anyone please assist me to correct the below formula?
=IFERROR(IF(OR(LEN(LEFT(A2,FIND("-",A2)-0))=5,LEN(LEFT(A2,FIND("-",A2)-0))=4),"FOUND","NOT FOUND"),"NOT FOUND")
I have worked on the formula, but it doesn't seem to work fine for all data. It worked for some and failed for some.
Data in column (A) has product numbers in different length and arrangement.
I would like to assign column (B) to display "Found" whenever it finds the following two product formats:
1- XXXX-11111-000 (4 Letters at beginning, followed by "-" and 5 digits, followed by "-" and 3 digits at the end) - Should display "FOUND"
2- XXX-11111-000 (3 Letters at beginning, followed by "-" and 5 digits, followed by "-" and 3 digits at the end) - Should display "FOUND"
All other products should display "NOT FOUND"
Any early response is appreciated,,,
Regards,
Zare
Could anyone please assist me to correct the below formula?
=IFERROR(IF(OR(LEN(LEFT(A2,FIND("-",A2)-0))=5,LEN(LEFT(A2,FIND("-",A2)-0))=4),"FOUND","NOT FOUND"),"NOT FOUND")
I have worked on the formula, but it doesn't seem to work fine for all data. It worked for some and failed for some.
Data in column (A) has product numbers in different length and arrangement.
I would like to assign column (B) to display "Found" whenever it finds the following two product formats:
1- XXXX-11111-000 (4 Letters at beginning, followed by "-" and 5 digits, followed by "-" and 3 digits at the end) - Should display "FOUND"
2- XXX-11111-000 (3 Letters at beginning, followed by "-" and 5 digits, followed by "-" and 3 digits at the end) - Should display "FOUND"
All other products should display "NOT FOUND"
700-800-900-000 |
375-64-36 |
397-0-531 |
302-0230 |
300-5788 |
3008-453 |
FDCX-36514-850 |
30-06-937 |
300-6-9-38 |
DPZH-55121-001 |
DPZ-12412-315 |
LABEL B/YELLOW 18 M |
77001-00030 |
60352010005425 |
JD70-99VA/ZKM-E09QL4-F |
Any early response is appreciated,,,
Regards,
Zare