THE BORE
General => The Superdeep Borehole => Topic started by: Tieno on May 29, 2010, 03:30:58 PM
-
I got two lists
List 1 and list 2
List 1 is a list of id's with a corresponding e-mail adres.
List 2 is a longer list of largely the same id's, but no e-mail adresses.
I need to copy the e-mail adres to the corresponding id's on list 2. I can't filter out the the duds, it needs to be like this.
-
You mean like this?
-
there's nothing there.
Basically it's like this (id and e-mail are different cells)
L1
id15 e-mail
id29 e-mail
id34 e-mail
id27 e-mail
L2
id15
id16
id29
id14
id34
id8
id27
id45
I need to e-mails in list 1 copied to list 2 at the corresponding id. I need it like that cause I need to paste list 2 in another excel sheet and need to keep the order and number of cells.
-
Just do a vlookup
if list1 is in columns 1 and 2, and say list 2 is in column 5, then this would work in column 6
=vlookup(E1,$A$1:$B$n,2,false)
n is just a placeholder because I don't know how large your range is, its just the number of rows for list1. Copy the formulas down column 6 and there you go ;)
-
oh yeah, if there were id's in list2 that don't have corresponding email addresses in list1, then the lookup will return "#N/A". So after you're done, select column 6 and ctrl + F replace these error values with ""
-
Thanks, worked like a charm.
Excel :bow2
VLOOKUP :bow2 Really need to learn to use this function
I used a scrapper to gather e-mail adresses from an old database I need to transfer to a new one. Only have access to the old database in plain html.
Cut out a lot of work like this. Outwit Web + Excel + Bore + VLOOKUP :bow2