Associating specific text in a cell to return values from a table

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.