Need to return a value from a chart with 2 criteria

[valley01]

My first post and I have experience with the very simple Excel formulas only. I have a simple chart (attached... I hope). I need a formula that will return a value based on the row and column criteria. For example, if I enter 250 in the "Tonnage" cell D14 and 3 in the "Qty" cell D15 it will show $1,200 in the "Cost" cell D16 based on the chart. I have played around with the Index, Match, and Vlookup but I'm in over my head. Any help would be greatly appreciated!

[djapigo]

Try this...

=INDEX($B$6:$D$11,MATCH(D14,$A$6:$A$11,0),MATCH(D15,$B$5:$D$5,0))

[valley01]

Thank you so much! It works perfectly for column B criteria (Criteria of 1). That is way further than I was able to get. How do I add Qty 3 and Qty 4 criteria?

[valley01]

Actually with your help getting me started I just figured it out. Thanks again, I really appreciate it!