I have two excel files: A full customer list with e-mails, and another abridged list in which the customer e-mails are not present. How would I go about creating a subset of the full customer list which matches the abridged list so that I may copy the e-mail field over to the shorter list?
Welcome to the forum. Be sure to read through the Forum Rules so you can use and follow them effectively. For instance, it is inappropriate to solicit questions through Private Messages, the point of the forum is to discuss thing openly to the benefit of all who come here to research on their own. It's is expected you will create a message like this one, then send Private Message invitations to those threads (add a link). Those rules benefit you greatly, so read through them all.
The formula I would use would go something like this.
Sheet1
Col A - First Names
Col B - Last Names
Col C - email
Sheet2
Col A - First Names
Col B - Last Names
==========
In Sheet1, cell D1, add this "key" formula:
=A1 & "|" & B1
....copy that cell down your data set to add a lookup key for each row.
==========
In Sheet2 in cell C1, put this lookup formula:
=INDEX(Sheet1!$C:$C, MATCH($A1 & "|" & $B1, Sheet1!$D:$D, 0))
...and copy that down the data set to get the emails to appear.
_________________
Microsoft MVP 2010 - Excel
Visit: Jerry Beaucaire's Excel Files & Macros
If you've been given good help, use theicon below to give reputation feedback, it is appreciated.
Always put your code between code tags. [CODE] your code here [/CODE]
?None of us is as good as all of us? - Ray Kroc
?Actually, I *am* a rocket scientist.? - JB (little ones count!)
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks