troubleshooting Question

Help with Excel and Upper Lower Bounds, may be and Index/Match

Avatar of Andrea Bernard
Andrea Bernard asked on
Microsoft ExcelMicrosoft Office
1 Comment1 Solution125 ViewsLast Modified:
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!!!
Wayne Taylor (webtubbs)

Our community of experts have been thoroughly vetted for their expertise and industry experience.

Join our community to see this answer!
Unlock 1 Answer and 1 Comment.
Start Free Trial
Learn from the best

Network and collaborate with thousands of CTOs, CISOs, and IT Pros rooting for you and your success.

Andrew Hancock - VMware vExpert
See if this solution works for you by signing up for a 7 day free trial.
Unlock 1 Answer and 1 Comment.
Try for 7 days

”The time we save is the biggest benefit of E-E to our team. What could take multiple guys 2 hours or more each to find is accessed in around 15 minutes on Experts Exchange.

-Mike Kapnisakis, Warner Bros