Formula that recognizes data from a drop down list selection

[dwoodson297]

I am a somewhat beginner at advanced excel spreadsheets...tried to up my skills.

I want to be able to select an item from a list and have a formula that uses a a variation of its information.

For example, In column A, I have a drop down list with multiple items (4x8x16, 8x8x16, etc). In Column B, I want it to recognize my selection and input a corresponding area (4x16 or 8x16 in this case) into a formula. So if I select 4x8x16 from the list, I want 4x16 or 64 to be automatically inserted in my formula. If I select 8x8x16 then it would insert 8x16 or 128.

I hope this makes sense. Any suggestions?