aligning data
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. |
aligning data
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. |
aligning data
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. |
All times are GMT +1. The time now is 11:24 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com