Cross reference two spreadsheets

[ksaab]

Thank you for reading this!

I am not a spreadsheet person..BUT

I have two spreadsheets - each have Employee ID #'s one has emails one does not...

How do I "Link" the tables on Employee ID and add emails to the spreadsheet without them.

I could do this in Access but this is a solution for an end user who ONLY has access to Excel.

Thanks!

 

[HaHoBe]

Hi, ksaab,

have a look at the VLookup function in the Online Help, maybe with an IsError-Trapping to the formula. A1 holds the ID which is located on column A in Sheet2 as well while column B holds the email address:

=VLOOKUP(A1,Sheet2!A:B,2,0)

=IF(ISERROR(VLOOKUP(A2,Sheet2!A:B,2,0)),"",VLOOKUP(A2,Sheet2!A:B,2,0))

Ciao,
Holger