I have a long list of error. I need to make a separate vlook table. For example, in the example below. I want to make a lookup table that says: "Only one allowed per shipment" and then I want my formula to ignore the "supplier","warehouse" and "product" part in the table below give me "1" as the error reason. I tried doing partial text but seems like it works better for continous words. Can you please help me.
Error | Error Number |
Only one supplier is allowed per shipment | 1 |
Only one warehouse allowed per shipment | 1 |
Only one product allowed per shipment | 1 |
Purchase order ABC1234 does not exist in whse: MBA | 4 |
Purchase order ABC2345 does not exist in whse: BNA | 4 |