Need Excel halp again

[Tieno]

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.

[Madrun Badrun]

You mean like this?

[Tieno]

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.

[Kestastrophe]

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 

[Kestastrophe]

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 ""

[Tieno]

Thanks, worked like a charm.

Excel
VLOOKUP 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