Unanswered: Evaluating a value to get score from a range
I am trying to assign a score based on a value from a cell by using a formula.
I tried to use a "nested if" but I have 10 possible values and the limit is 7.
Plus it is messy and hard to read. Is there a easier way?
Below is an example:
Column B has my values and C is where I want the score
The score is based on a range stored on another worksheet:
A B C
Score MinValue MaxValue
1 0 10
2 11 20
3 21 30
10 91 100
VLOOKUP is great. I have a suite of forms that use it to validate and translate user input!
HLOOKUP is similarly powerful, and works at right angles to VLOOKUP. It gets used less, though, because we're more familiar with lists and tables that are vertical rather than horizontal.