Hi. I have a data table example as follows:

Column A Column B Column C Column D Column E

Product Code Cost Quantity Quantity Quantity


25 50 75
5678 2 1.3 1.25 1.2


2356 3.5 2.0 3.5 3.1
4578 3.0 1.2 4.3 4.0

In a separate workbook to the data table I want to select say the product code (5678) and quantity required (25) from drop down menus and to then return the value 2 x 1.3 = 2.6 into a sales price cell. Next time I could select code 4578 with quantity 75. Then I need to multiply 3 x 4 = 12.

If anyone can show me the formula(s) to use it would be appreciated as I am getting no where with this,

Thanks