Help combining two worksheets

[ADO]

I wondered if someone might explain to me how to create a
spreadsheet combining the data from two others. I have
two sheets - one has 2000 names and email addresses and
the other just has 1000 names. I want a sheet with just
the 1000 names and their email addresses. If the name is
in the one sheet of 1000, then I want it on the third
sheet with the corresponding email address from sheet 1.
Any idea how to do this?

 

[Andy B]

Hi

With your 2000 names in Sheet1 cells A2:B2001, try:
=VLOOKUP(A2,Sheet1!$A$2:$B$2001,2,false)
in Sheet 1 B2, with your existing name in A2
This looks up the name in A2 (in the range on Sheet2) and returns the
relevant email address. You can then fill this down the other 999 rows.

 

[Guest]

Thanks Andy, I'll give it a shot.
Ann

-----Original Message-----
Hi

With your 2000 names in Sheet1 cells A2:B2001, try:
=VLOOKUP(A2,Sheet1!$A$2:$B$2001,2,false)
in Sheet 1 B2, with your existing name in A2
This looks up the name in A2 (in the range on Sheet2) and returns the
relevant email address. You can then fill this down the other 999 rows.

--
Andy.





.