Multi Lookup Problem

[Kbroccardo]

Hi,

Relatively new to the group but having a major problem with this formula. I've got half of it working but not the rest. I looked for solutions on the message board but couldn't find the exact solution.

Anyhow, I'm creating a form that is going to have two data validation lists that are customer inputed. I need to create a formula that will look up both data points the customer has input and locate the pricing for that item.

I've been using the index match formula and have gotten 1 half of the equation to work. It would be where the customer has input a product and it located the price but not both points.

The formula I have right now is:
=INDEX(price!$I$10:$I$347,MATCH(A17,price!$A$10:$A$347,0)) that finds the product and price
but I need this formula to look at column d (another data validation list) then match the product and machine classification to come up with the price.

I don't know how to add my spreadsheet so you can look at it so I'll do the best at explaining.

a17 is the location of the product drop down validation list
Price! I is the pricing of the product
d17 will be where the customer inputs the machine classification and will also look to price! I to get the pricing.

I have tried to do 2 matches in the same equation and I either get a #ref error or a #n/a error.

Please help, I'm going crazy!!

Karen

 

[Kbroccardo]

Got it all figured out with the help of you great guys on the board.

I concatenated the two columns and that solved my problem.

Thanks for all of your help, this board is really a great resource!

Karen