Shank
Reputation: 685
Excel formula to return a value based on specific range
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.
Upvotes: 1
Views: 653
Answers (1)
Mayukh Bhattacharya
Reputation: 27233
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)
Upvotes: 2
Related Questions
- How can I write an excel formula to return a value from a range based on the contents of a cell?
- Return a value based of three different ranges
- Return the value from a range that matches with another cell
- Excel: returning value in range based on 2 criteria
- Excel formula to return value based on cell value within a range
- How to get a specific output if a value is within a range
- Excel return value that falls within a range
- Excel formula to return a value from a range where conditional statements are true
- Returning value from range for any of the values that are looked up
- How to return a value from a range of values