Working on Specfic Text in a cell and compute with a lookuptable and provide result

Hi Friends,

Good Day!. I am very glad to see this website.

I am a MBA Student. I am doing my project in Inventory Management. In My Excel Sheet I have to segregate the items. Let me Explain.

Item Description Holds Item Number, Item size Variant 1 and Variant 2. Based on item No VAriant1 & Variant 2 l Above i Have to assign a value.

FYI: Item no is unique and all others are different.

Please help me out. Thanks in Advance.

Encl: Practice.xlsx

Regards,
Prasad