Fill appropriate value to a cell

[pitarda]

I have one sheet with address data and another sheet with e-mail address data. Now I need to add email address to a cell in first sheet according to name (if sheet 2 has Andrew with email address, then fill in a cell in sheet 1 with this email address):

sheet1:

Andrew Address email_from_sheet2
Joe Address email_from_sheet2

sheet2:

Will Email_address
Joe Email_address
Frank Email_address
Andrew Email_address


Is it possible?

Thanks.

[noranthon]

Assuming the names and email addresses are in different columns, you could use VLOOKUP (on its own) or INDEX with MATCH.
_________________
search forum by month

[Mark B]

Hi

If you're still wondering how to do this then have a look at the Flash tutorial that I created at http://www.linuxtalk.co.uk/forum/Blah.pl?m-1180812130/

Mark
_________________
Mark B's Articles