Forum Discussion
Solved
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 hav...
=INDEX(Price_Range, MATCH(Specific_Product, Product_Range, 0), MATCH(Specific_Number_of_Users, Number_of_Users_Range))
=INDEX(Price_Range, MATCH(Specific_Product, Product_Range, 0), MATCH(Specific_Number_of_Users, Number_of_Users_Range))