Avatar of Andrea Bernard
Andrea Bernard

asked on 

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

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!!!
Microsoft ExcelMicrosoft Office

Avatar of undefined
Last Comment
Wayne Taylor (webtubbs)

8/22/2022 - Mon