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