What formula do I use for this? Help!

[banana1975727]

hello

I have a column (C) of about 1700 names with their respective email addresses in the adjacent column (D) of sheet 1. Sheet 2 only has the names, not email addresses.

What formula do I use to match up the names and automatically add the corresponding email address to the blank adjacent cell on sheet 2?

I appreciate your help!!! Thank you!

 

[Marcelo Branco]

Hi,

Welcome to the forum

Assuming your data in Sheet1 (columns C and D) beginning in row 2 (headers in row1)

and

in Sheet2 the names in column A beginning in row 2, maybe something like
Formula in B2
=VLOOKUP(A2,Sheet1!$C$2:$D$2000,2,0)
copy down

Check if the names in Sheet1 dont have leading or trailing spaces. Just in case...

HTH

M.

 

[banana1975727]

Thanks for your reply and welcome, Marcelo!

However, the vlookup didn't work. Let me explain better what I'm looking to do. I tried to insert an image of my workbook, too, but I don't know if it worked or not. Sorry, still new here!

Sheet 1 has about 100 names beginning in column D, row 3. The adjacent column C is blank, but needs email addresses.

Sheet 2 has about 1600 names beginning in column A, row 2. Their corresponding email addresses are in column B, row 2 and so on.

I want Excel to find the matching email addresses from Sheet 2 and input the data into Sheet 1, column C, row 2 and so on.

Your help is greatly appreciated!

 

[kpark91]

Welcome to the forum, banana.

From your last post, I understood your problem as looking up a value in Sheet2 to put matching email addresses in Sheet1(C).

So, in Sheet1(C3) try

=VLOOKUP(D3, Sheet2!$A$2:$B$1602, 2, 0)

and then copy down.

 

[Marcelo Branco]

Welcome to the forum, banana.

From your last post, I understood your problem as looking up a value in Sheet2 to put matching email addresses in Sheet1(C).

So, in Sheet1(C3) try

=VLOOKUP(D3, Sheet2!$A$2:$B$1602, 2, 0)

and then copy down.

I agree, but be sure that the names are exactly the same in both sheets. (the same formula i posted in #2, adjusting the lookup-value and the ranges)

Sometimes leading or trailing spaces or anything else provoke the #N/A results.

M.

 

[banana1975727]

AWESOME!!! Thank you so much for your help... Now that I understand this formula better I can use it all over my workbook!

 

[banana1975727]

AWESOME!!! Thank you so much for your help... Now that I understand this formula better I can use it all over my workbook!

P.S. I did have 3 names that were not identical and got the N/A error... Easily fixed though because it was only 3 out of the 100 or so!!