Formula Question

[thrashgmom]

I have a list of employee names, 45,000 rows long. I also have a shorter list of some of these names with email addresses, only 6000 rows long.

I am trying to match up the email addresses from the short list with the names on the longer list, so I know who I have an email address for and who I don't.

Using VLookup, I am getting the matches, but for the rows that do not have a match, I am getting repeat information from the last match - how to I get it to return a blank for the rows that do not have matching information on the other list?

I am thinking VLookup is not the right thing to use but am drawing a blank on what I should use.

Any thoughts?

First time poster....

 

[GlennUK]

Are you using FALSE as the 4th argument of your VLOOKUP function?

 

[Aladin Akyurek]

Woud you post the formula you have been using?

 

[T. Valko]

I have a list of employee names, 45,000 rows long. I also have a shorter list of some of these names with email addresses, only 6000 rows long.

I am trying to match up the email addresses from the short list with the names on the longer list, so I know who I have an email address for and who I don't.

Using VLookup, I am getting the matches, but for the rows that do not have a match, I am getting repeat information from the last match - how to I get it to return a blank for the rows that do not have matching information on the other list?

I am thinking VLookup is not the right thing to use but am drawing a blank on what I should use.

Any thoughts?

First time poster....

Did you set the 4th argument to be 0 or FALSE so that it looks for exact matches only?

Post the formula you're using.

What version of Excel are you using?