Ok. Thanks simply for reading this. I heard you guys are life savers.

I have a LARGE document, with say.. 10,000 names in it and no emails;.
and I have another, made later, with 11,000 names and emails in it.
The 10,000 name database however has each of the entries sorted, which
was done manually, into different categories.
What I am looking for is a way of getting the emails from the larger
document to snap into a column in my older sheet, so all the
information is correlated, I don't have to put names to emails manually
all over again, and discards the 1000 or so other entries, which are
scattered all over the show. Any ideas?

Any questions I can answer/send a screenshot if that helps!


Jos.

look in Excel help at the vlookup worksheet function

--
Regards,
Tom Ogilvy


" wrote:

Ok. Thanks simply for reading this. I heard you guys are life savers.

I have a LARGE document, with say.. 10,000 names in it and no emails;.
and I have another, made later, with 11,000 names and emails in it.
The 10,000 name database however has each of the entries sorted, which
was done manually, into different categories.
What I am looking for is a way of getting the emails from the larger
document to snap into a column in my older sheet, so all the
information is correlated, I don't have to put names to emails manually
all over again, and discards the 1000 or so other entries, which are
scattered all over the show. Any ideas?

Any questions I can answer/send a screenshot if that helps!


Jos.

Hi
If you are in Excel then you can use VLOOKUP.
Suppose your first range with names and no emails (addresses??) looks
like this:

Name Email
john
mary
bill
larry

and your other looks like this

Name Email
eddie text1
bill text2
mary text3
larry text4

1. Select your first range and do Insert, Name, Define from the Excel
menu. Call the selection Range1 and click Add.
2. Select your second range and do Insert, Name, Define from the Excel
menu. Call the selection Range2 and click Add.
3. Opposite john in Range1 in the email column type
=VLOOKUP(A2, Range2, 2, False)
where I have assumed john is in cell A2.
This formula says "look for the john in Range2 and give me the text in
column 2 and don't worry about how the names in Range2 are sorted"
For my example, this will give an N/A result as john is not in Range2.
4. Select the whole email column in Range1 and do Edit, Fill, Down to
copy this formula down through Range 1.

regards
Paul

wrote:
Ok. Thanks simply for reading this. I heard you guys are life savers.

I have a LARGE document, with say.. 10,000 names in it and no emails;.
and I have another, made later, with 11,000 names and emails in it.
The 10,000 name database however has each of the entries sorted, which
was done manually, into different categories.
What I am looking for is a way of getting the emails from the larger
document to snap into a column in my older sheet, so all the
information is correlated, I don't have to put names to emails manually
all over again, and discards the 1000 or so other entries, which are
scattered all over the show. Any ideas?

Any questions I can answer/send a screenshot if that helps!


Jos.