Kbroccardo
New Member
- Joined
- Feb 19, 2004
- Messages
- 11
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
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