Cost Formula using multiple criteria
I have been beating my brain trying to make this formula work. Any help is appreciated. I have two sheets, the Sample Sheet and the Sample Pricing Sheet. I want to be able to fill in the customer with the pricing options and product(s), then have the product cost autofill under the correct column(s).
The products have a standard and an option pricing. A customer could be getting multiple products. If they get product 1, I would like for the correct pricing (standard or option) to appear in that column. If they get product 2 the same. Screenshots below to hopefully help. Thank you in advance from the currently braindead. :)
Help Article Resources
Check out the Formula Handbook template!