All right,
So my problem is thus:
I am exporting data from a inventory control system. This system gives me a material description. Our work area has 3 different zones that the material is run in.
Here is what I need. I need to be able to paste my information in and based off the material description I want a formula to look in a 2 column table and match up the description with the zone number.
I have attached the sheet.
Bookmarks