Lookup names to get data

E

Ed Wesemann

I have two name and address lists. List A is the larger list (13,000 rows)
and has names and telephone numbers along with other data. List B is smaller
(5900 rows) and almost all names on List B are also on list A. What I want
to do is look up each name on List B in List A and copy the corresponding
telephone number for the name ifrom List A to a blank cell next to the name
in List B. It seems like it should be some sort of lookup function. Any
help would be appreciated to save me a lot of cutting and pasting. Please be
specific in any instructions...I'm way over my head with this one. Thanks in
advance.
 
A

Aladin Akyurek

Care to provide exact ranges along with the sheet names which house List
A and List B?
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top