I have a list of item codes, and they all belong to some overarching item. Like 'F9', 'F9 Pro', 'F9 Billing', are all under the item F9.
I have data that shows customers and all their item codes, but no item. So I have an Excel document that lists all the mappings. I tried to do a long nested if statement in the script, but it is limited to 100, and there are about 120 mappings.
I believe I can map directly through the excel doc, can someone help me with this?