View Single Post
  #1   Report Post  
Ed Wesemann
 
Posts: n/a
Default 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.