Solution for if x = 1 and Y =2 goto C3

[Neall]

Good day, I am hoping someone can help me with this formula

I have a result sheet and on the result sheet I have a section that shows
the part number (c33) and a price level (O5), along with quantity (G18)

These part numbers and price levels are on another sheet (prices) with
pricing. On the prices sheet the part numbers are in column B22 - B41 and
price levels from in Row C21 - N21. inbetween are the actual prices per part
number per price level (like a multiplication table where if you run your
finger from level G down and accross from part X you will find the
corresponding price)

what I am looking for in the tally sheet is from another cell (P42)
calculate the formula stating that if part number = X and price level = I
take the intersecting price (from the price sheet) and multiply it by the
quantity on the tally sheet and place the total in Q33.


Can anyone help me with this?

Thanks in advance

 

[Luke M]

Place this into Q3. Adjust sheet names within single quotations as needed.

=INDEX('Prices'!C22:N41,MATCH('Result
Sheet'!C33,'Prices'!B22:B41,0),MATCH('Result
Sheet'!O5,'Prices'!C21:N21,0))*'Result Sheet'!G18

 

[Neall]

Thanks, I am having one problem however it doesnt seem to be gathering the
data from the table (prices)

the table looks something like this

Part number level A - B - C - D - E
11 $1 $2 $3 $4 -$5
12 10 15 16 18 20
13 20 22 24 26 30

So what I am looking for is if the tally sheet has a part number of 11 and
level is D to then multiple $4 X the number of units.

maybe I am missing something but I am not getting the correct result with
the info you gave me.

Any suggestions

Thanks