View Single Post
 
Old 02-07-2015, 03:40 PM
oswald oswald is offline Windows 7 64bit Office 2013
Novice
 
Join Date: Feb 2015
Posts: 1
oswald is on a distinguished road
Default 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
Reply With Quote