Lookup names to get data

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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.
 
Care to provide exact ranges along with the sheet names which house List
A and List B?
 
You must log in or register to reply here.

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

Similar Threads

Anyone Else Facing Public Folder Migration Errors in Exchange? 0
Cross referencing data in Excel 4
Lookup formula of some sort 4
Multiple List Analysis 0
resettable, over-ridable, default cell values 0
Excel Lookup 1
Lookup and Copy Data 1
How can I migrate MBOX to PST? 2

Back
Top