I have some data with a list of Product IDs and I want to assign the Product IDs a category name based on specified criteria. Some examples are below.
IIF Product ID = #*C#* then category name = Cable
IIF Product ID = 00#* or 497* then category name = Component
...
I can get it to work using...