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

--
AP

"mun04" <[email protected]> a écrit dans le
message de news:[email protected]...
>
> 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
>
>
> --
> mun04
> ------------------------------------------------------------------------
> mun04's Profile:
http://www.excelforum.com/member.php...o&userid=32145
> View this thread: http://www.excelforum.com/showthread...hreadid=518993
>

[Ardus Petus]

BTW, VLOOKUP works like a charm!

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

HTH
--
AP

"mun04" <[email protected]> a écrit dans le
message de news:[email protected]...
>
> 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
>
>
> --
> mun04
> ------------------------------------------------------------------------
> mun04's Profile:
http://www.excelforum.com/member.php...o&userid=32145
> View this thread: http://www.excelforum.com/showthread...hreadid=518993
>

[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)

--
AP

"mun04" <[email protected]> a écrit dans le
message de news:[email protected]...
>
> 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
>
>
> --
> mun04
> ------------------------------------------------------------------------
> mun04's Profile:
http://www.excelforum.com/member.php...o&userid=32145
> View this thread: http://www.excelforum.com/showthread...hreadid=518993
>