Any chance you would reconsider the set up? It would be much easier if
you had the numbers in col A and the names in col B. Also, be sure to
have the list sorted ascending on col A.

Then you can use this simple formula:

=VLOOKUP(D1,A1:B50,2,FALSE)


Sweeny Wrote:
I have a list of 50 names in column A and a list of corresponding
numbers in
Column B. If I insert one of the numbers in Col B into a cell in Col D,
how
can I get the corresponding name to appear in adjacent cell in column
E?
--
Sweeny


--
Lilliabeth
------------------------------------------------------------------------
Lilliabeth's Profile: http://www.excelforum.com/member.php...o&userid=27741
View this thread: http://www.excelforum.com/showthread...hreadid=476642