[Roo06]

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
B C
Value1 Score
10
20
30
25
15

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
...up to
10 91 100

[georgev]

Have you tried a VLookup?

[weejas]

VLOOKUP would work, but you'd need to change your Scores table a little. Move the Score column to the end of the range, and name it for ease of reference.

[Roo06]

That worked like a charm. I have never used VLookUp but its seems really powerful.

[weejas]

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.

[georgev]

Personally I hate VLookup, but only because when I've used it it's been across worksheets containing 60K records and any update anywhere forces full cell recalculation... Taking upwards or 15 minutes