Lookup Formula

B

BAD

I have worksheet #1 that has Name and Email Address.

I have worksheet #2 that has Name and Employee ID number.

I want to add a cell next to Employee ID number called email address. The
formula in this cell should be something like, Lookup the name in Worksheet
#1 and if it matches Worksheet #2, give the email address.

THe worksheet #1 with the email address has lots of outdated email addresses
and I am trying to retrieve only the current employees from that worksheet.

Any suggestions if this is even possible?
 
R

RagDyer

A simple Vlookup formula should do.

Sheet1 - name in A2 to A100,
e-mail in B2 to B100

Sheet2 - Name starting in A2.

In C2 of Sheet2, enter this formula:

=IF(ISNA(MATCH(A2,Sheet1!A$2:A$100,0)),"",VLOOKUP(A2,Sheet1!A$2:B$100,2,0))

And copy down Column C as far as you have names in Column A.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

VBA Coding Help for Beginner 0
Outlook 365 not saving sent messages. 1
Duplicate pst, or is it? 1
One note creating multiple tabs when collaborating? 0
Scrubbing two excel worksheets, returning unique values from one sheet 0
Insert name and adress from a list in a word document 1
Auto populate value from one task to another in MS PROJECT 0
We try to save msg in got the error in outlook 2021/office 365 0

Top