How to return a value in a data table using vertical and horizontal criteria
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
|