Forum Discussion
ClarkMattison
Mar 19, 2024Copper Contributor
Two way Lookup/Index Match help
Trying to figure out the right formula to approach this scenario. Need to be able to determine price based on product and number of users. I have tried a few options I have seen online but am not having any luck. We are working on a new pricing grid and this would go a long way in simplifying process. Thanks!
=INDEX(Price_Range, MATCH(Specific_Product, Product_Range, 0), MATCH(Specific_Number_of_Users, Number_of_Users_Range))
1 Reply
Sort By
=INDEX(Price_Range, MATCH(Specific_Product, Product_Range, 0), MATCH(Specific_Number_of_Users, Number_of_Users_Range))