=INDEX(A:A,MATCH(D2,B:B,0))

--

HTH

RP
(remove nothere from the email address if mailing direct)


"Sweeny" wrote in message
...
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