Level Low High
1 $140,000 $155,000
2 $125,000 $155,000
3 $115,000 $145,000

How do I get a formula to look up a salary of $130,000 within the low and
high range to place the Level "2" into a cell?

Nikki,

Why does $130k return a 2, why not a 3? Please explain the rules.

Mike

"Nikki" wrote:

Level Low High
1 $140,000 $155,000
2 $125,000 $155,000
3 $115,000 $145,000

How do I get a formula to look up a salary of $130,000 within the low and
high range to place the Level "2" into a cell?

sort
3 115000 145000
2 125000 150000
1 140000 155000

and then just use a vlookup
=VLOOKUP(J1,H1:I3,2)
to get 150,000
--
Don Guillett
Microsoft MVP Excel
SalesAid Software

"Nikki" wrote in message
...
Level Low High
1 $140,000 $155,000
2 $125,000 $155,000
3 $115,000 $145,000

How do I get a formula to look up a salary of $130,000 within the low and
high range to place the Level "2" into a cell?

I already have the level so I need to make sure the is they are a level 2
then the salary of 130,000 is within the range.

"Mike H" wrote:

Nikki,

Why does $130k return a 2, why not a 3? Please explain the rules.

Mike

"Nikki" wrote:

Level Low High
1 $140,000 $155,000
2 $125,000 $155,000
3 $115,000 $145,000

How do I get a formula to look up a salary of $130,000 within the low and
high range to place the Level "2" into a cell?