Name Findout From a interval range

[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

[random1970]

Here's a simple way around it.

Insert a column before your name and salary columns. This will mean your names are now in column B and salaries in column C.

In cell A1, type =C1. Fill this down. This copies the salaries into column A. Use your VLOOKUP function to find a value in column A and return the name in column B. e.g. If the required salary is in F1, type =VLOOKUP(F1,$A$1:$B$4,2,true) into F1. The name you want should appear in F2.

If you don't want the extra column to show, format the font in column A as white, or just hide the column.

[Ardus Petus]

Without any extra column:

=INDEX($A$1:$A$4,MATCH(F1;$B1:$B4;0))

HTH
--
AP

"random1970" <random1970.246zsa_1141554901.4419@excelforum-nospam.com> a
écrit dans le message de
news:random1970.246zsa_1141554901.4419@excelforum-nospam.com...
>
> Here's a simple way around it.
>
> Insert a column before your name and salary columns. This will mean
> your names are now in column B and salaries in column C.
>
> In cell A1, type =C1. Fill this down. This copies the salaries into
> column A. Use your VLOOKUP function to find a value in column A and
> return the name in column B. e.g. If the required salary is in F1,
> type =VLOOKUP(F1,$A$1:$B$4,2,true) into F1. The name you want should
> appear in F2.
>
> If you don't want the extra column to show, format the font in column A
> as white, or just hide the column.
>
>
> --
> random1970
> ------------------------------------------------------------------------
> random1970's Profile:
http://www.excelforum.com/member.php...o&userid=32112
> View this thread: http://www.excelforum.com/showthread...hreadid=518996
>