Hello

I need a little help.

I am trying to make a list that displays a material size but the actual value is different then what is displayed.

So a list would Read
Displayed Value for calculation
1x4 3 1/2
1x6 5 1/2
1x8 7 1/2
1x10 9 1/2



What im trying to create is this

Side material Top Material
(from list) 1x4 (From list) 1x8
value for calc 3 1/2 value for calc 7 1/2

I would like to be able to do a formula like side material 1x4 + top material 1x8 *2 +1 and the answer be 19 1/2

Hope this makes sense I really appreciate the help. Im just learning how to try and do a lot more with excel for calculating various things we build in a home like mirror frames, doors, timber trusses. Its crazy how much time the little bit I have tried has saved me.