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

To select a value in your table use the INDEX function combined with MATCH. It is well-documented. This will return one value. I don't see where you get the second one to perform the multiplication?

__________________
Did you know you can thank someone who helped you? Click on the tiny scale in the right upper hand corner of your helper's post