If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Lookup names to get data
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. |
#2
|
|||
|
|||
Care to provide exact ranges along with the sheet names which house List
A and List B? Ed Wesemann wrote: 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. |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Format on data to import to Access tables? (I need your advice) | Niklas Östergren | General Discussion | 5 | December 13th, 2004 02:54 PM |
transpose | john | Using Forms | 1 | November 24th, 2004 06:16 PM |
Lookup with Random Data | PFH | General Discussion | 1 | October 7th, 2004 07:17 PM |
SQL view of messed up action queries | Kendra | Running & Setting Up Queries | 2 | August 31st, 2004 09:53 PM |