Hi there! I'm trying to return the priceTierLabel, given the price and the class. So if the Class is 110 and the price is $27.97, then I would want to return "Medium". I am having a hard time figuring out if to start with an If Statement, Index Match..... Hope the all below posts OK and lines up...
Class priceTierLabel Lower bound Upper bound
101 Low $0 $59.99
101 Medium $60.00 $149.99
101 High $150.00 $499.99
101 Very_High $500.00 $99,999.99
110 Low $0 $23.99
110 Medium $24.00 $99,999.99
115 Low $0 $15.99
115 Medium $16.00 $99,999.99
120 Low $0 $19.99
120 Medium $20.00 $49.99
Thank you!!!