I have a column of 160+ names in column A & phone numbers in column B on
worksheet 2.
On worksheet 1, I have some of those names in column A. There are 5 more
columns of information.
These names and the rest of the info, on worksheet 1, may change on a daily
basis and some names may appear more than once.
Rather than type in all the phone numbers on worksheet 1, is there a way to
have the numbers inserted into worksheet 1?

Any help would be greatly appreciated.
Dennis

=VLOOKUP(A1,Sheet2!$A:$B,2,False)

--
---
HTH

Bob

(change the xxxx to gmail if mailing direct)


<Excel wrote in message
...
I have a column of 160+ names in column A & phone numbers in column B on
worksheet 2.
On worksheet 1, I have some of those names in column A. There are 5 more
columns of information.
These names and the rest of the info, on worksheet 1, may change on a
daily
basis and some names may appear more than once.
Rather than type in all the phone numbers on worksheet 1, is there a way
to
have the numbers inserted into worksheet 1?

Any help would be greatly appreciated.
Dennis

Your formula worked like a charm. Saved me hours of typing.
Thank you Very much
Dennis