VLookup v 7 nested IF functions

[Zakynthos]

I want to evaluate more than 7 conditions in a cell where I want to give a
unique score to up to 15 variables and know I'm limited to 7 with a nested IF
function.

If, in cell B3 I wanted to lookup the values and assign a score of '1' for
value x, '2' for value x+3, '3' for variable x+17 ... etc to '15' for value
x+39 what would be the form of a Vlookup function to get these scores
correctly input?

Many thanks!

 

[Toppers]

Is x a constant or variable? If the latter, there could be problems.

 

[Zakynthos]

Toppers,

No, x is a CONSTANT - probably I din't express it very well - let's say the
values in cell cell B3 were, 15, 22,36,48,46,17,19,30 ... etc up to 15 values
and I wanted to place a score in C3 for each of these values, say a '1' for
the first value 15, a '2' for the second value 22 etc.

Sorry I wasn't very clear!

Tony

 

[Bob Phillips]

=MATCH(C2,{15,22,36,48,46,17,19,30},0)

--
HTH

Bob

(there's no email, no snail mail, but somewhere should be gmail in my addy)

 

[Zakynthos]

Bob,

Fantastic, just what I was looking for!

Thanks a lot,

Best wishes,

Tony