Hello, I am in need of a formula that will be able to identify the Right most and Left most characters to produce a defined output. A standard If statement limits me to 6 defined outputs, but I will have an undefined number of outputs. My goal is to be able to define the output based on a set table. Then when a new Part Number is entered, it will result in the defined output based on the Most Right and Most Left 3 characters.
|
|
|
| ||||
| 604 | 799 |
| ||||
| 603 | 447 | ABC321 | ||||
| 403 | 340 | 123ABC | ||||
| 680 | 148 | 321ABC |