Multiply two cells based on information in two other cells

Hi
I am looking to get a formula for working out Metres of wire based on material type, diameter and weight
I have 2 cells where the information is validated from a list
The first is material type and the list contains things such as stainless, brass etc
The second is wire diameter and has a list from 1 to 5mm
On a separate page I have a list of materials weights and metres for example stainless 1mm diameter = 161 m per kg

I need a formula that checks what material is selected from the list, then checks what diameter is selected from the other drop down list. Based on this selection it looks up the number of m per kg for that material type and diameter from the list I have generated and then multiplies it by the figure in another cell which is order qty

The purpose of this is so that when I select a material then select a diameter and then enter an order qty in KG another cell is populated with the amount of metres I will end up with
So in theory material type and diameter determine the number of m per KG and then it auto multiplies it my order qty and displays in another cell

I have attached the sheet so you get a better understanding
I am selecting the diameter in D column, selecting material type in E column and entering an amount in KG in F column. On the second tab (m per kg chart) i need it to grab the associated figure (e.g. for 2 mm stainless the figure it should pick up is 40) and then i need this figure to multiply by the order qty in F column and display the final figure in G column


Please shout up if you need more information in order to be able to assist me

Many Thanks

Stanster

Set up the second tab (m per kg) so that it shows the material in every row along with the diameter. Than you can use a SUMIFS function to look up the row that satisfies multiple criteria and return a value from that row. See attached.


planner v2.xls

You sir are a legend
Works perfectly

Thanks so much you have saved me a huge headache

Regards

Stanster

Ok the previous works fantastic and I now have a further formula required to complete the sheet

I have attached the new version for you to look at

Basically I need to check machine loading hours so In columns N, P and R we can theoretically select the same machine to perform the task. I need to work out the total hours production for each of the machines

So if i select machine 1 in Column M , O or Q I want to add up all of the associated machine times for machine 1 which are calculated in Columns N,P and R

Currently on the attached sheet I have selected machine 1 in column M, Machine 2 in Column O and machine 3 in column Q. I would like to take the respective machine time for every time the same number appears of a machine in all 3 of these columns and give me a total hours to complete for all of the machines.

the same number could appear multiple times in M,O and Q and I would like to output this figure over to the right of the chart so it gives me a total hours completion for each machine

Hope that makes sense

thanks

Stanster