View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.newusers
AFSA Ad Intern AFSA Ad Intern is offline
external usenet poster
 
Posts: 2
Default How to clean one book using data from another?

Hello, I'm an intern and a relative new user of Excel. I've used it before,
but only for simple sorting.

Here's my problem:

I am using Excel '03 to sort e-mail address lists. I have two separate
files, one with names, email addresses, and postal addresses, and a "cleaned"
list with all non-working e-mail addresses removed.

What I want to know is, is there any way to use the second list to clean the
first list of all the people whose e-mail addresses no longer work, without
manually searching through them one row at a time? I have nearly 10,000 names
on one and over 7,000 on the other.

Thank you for your help!