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=518996

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

Without any extra column:

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

HTH
--
AP

"random1970" a
écrit dans le message de
...

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