Hi

The best solution will be rearranging columns - numbers in column A, and
names in column B. Then you can use VLOOKUP - like this:
E1=VLOOKUP(D1,A$1:B$50,2,0)

With your current setup, you have to combine INDEX and MATCH functions,
something like
E1=INDEX(A$1:A$50,MATCH(D1,B$1:B$50,0),1)


Arvi Laanemets



"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