vlookup match within a range

[Scholar]

Hello All,

I am trying to find a way to assign a preditermined value (from a table) to some percentages but can seem to find a similar function to do for me. What i need is like a vlookup to match WITHIN a range, like an inequality;

if x< -2.5 the lookup value should be 10
if -2.5<=x <= -2 the lookup value shoud be 9
if -2<=x <= -1.5 the lookup value shoud be 8

etcetera....

ANy help is much appreciated.

 

[Aladin Akyurek]

Hello All,

I am trying to find a way to assign a preditermined value (from a table) to some percentages but can seem to find a similar function to do for me. What i need is like a vlookup to match WITHIN a range, like an inequality;

if x< -2.5 the lookup value should be 10
if -2.5<=x <= -2 the lookup value shoud be 9
if -2<=x <= -1.5 the lookup value shoud be 8

etcetera....

ANy help is much appreciated.

Not very clear... Guessing that you want something like:

=LOOKUP(x,{0,-2.5,-2},{10,9,8})