VLookup v 7 nested IF functions
 

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!

VLookup v 7 nested IF functions
 

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

"Zakynthos" wrote:

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!

VLookup v 7 nested IF functions
 

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

"Toppers" wrote:

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

"Zakynthos" wrote:

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!

VLookup v 7 nested IF functions
 

=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" wrote in message
...
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

"Toppers" wrote:

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

"Zakynthos" wrote:

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!

VLookup v 7 nested IF functions
 

Bob,

Fantastic, just what I was looking for!

Thanks a lot,

Best wishes,

Tony

"Bob Phillips" wrote:

=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" wrote in message
...
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

"Toppers" wrote:

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

"Zakynthos" wrote:

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!