Excel formula to return a value based on specific range-CodePudding

Is there an easier way to write the equation w/o using too many AND conditions? I am trying to return "Amount" based on the range within which the growth rate falls.

CodePudding user response：

Posting it as an answer to show how LOOKUP() Function can also be used.

As Scott Craner Sir, suggested you can use VLOOKUP() Function with approximate match

• Formula used in cell C5

=VLOOKUP(C4,$E$9:$G$10,3)

However, you can also use LOOKUP() Function, just like as the screenshot shown above,

• Formula used in cell C6

=LOOKUP(C4,$E$14:$F$15)