Sort name from specified interval table

[mun04]

Hiiii
I am facing a silly problem i think u guys are rescue me from that...
My prob like I have two cloum one colum contain Name of person and
another coloum contain their salary.I prepared a interval table contain
4 row according to salary range....I have find the name whos salary has
on the specified range on ist row of interval table....

Can any one giv the idea about that..Perhaps I tried it VLook up
Function...But i faced proble to sort the name from ist colum

 

[Ardus Petus]

Here is an example, with INDEX & MATCH functions that don't need data
sorting

http://cjoint.com/?derO7Stjl6

HTH

 

[Ardus Petus]

BTW, VLOOKUP works like a charm!

see example: http://cjoint.com/?derUw5vDYX

HTH

 

[mun04]

Itried but failed.......Here is my prob demo

My prob like

TAZ 6000
RAZ 3000
GAZ 7000

Cat A 2000-5000
B 5000-8000
C 8000-10000

result would be

RAZ 3000 A
TAZ 6000 B
Gaz 7000 B

 

[Ardus Petus]

Here is my worksheet with your data: http://cjoint.com/?deu2j81iMj

The results are the same as yours, whichever the formula (INDEX/MATCH or
VLOOKUP)