Vlook up not working

[DEllis]

Hi, I am looking between 2 worksheets. Both have 3 columns A(Name & Email), B (Name) & C (Email)
What I need to do is look on worksheet A and find a name that is in column b on worksheet B to put in Column D. I am doing this to determine whose name is not on worksheet A that is on worksheet B (b has more names).
Here is my formula =IF(ISNA(VLOOKUP(B2,'Manual Listing'!$B:$B,1,0)),"Not Found",VLOOKUP(B2,'Manual Listing'!$B:$B,1,0)). I am getting all not found and clearly the name on the first sheet is the same name on the second sheet.

What am I doing wrong?

 

[Marcelo Branco]

Take a look at

Excel VLOOKUP Function Examples and Troubleshoot Problems

Excel VLOOKUP formula examples. Find product price. Change letter grades to numbers. Troubleshoot. Fix sorting problem. Videos, written steps, Excel file

www.contextures.com

Maybe there are extraneous characters, mostly spaces, in one sheet or in both. Check.

Hope this helps

M.

 

[Fluff]

Make sure that you don't have any leading/trailing spaces.
You can also use

=XLOOKUP(B2,'Manual Listing'!$B:$B,'Manual Listing'!$B:$B,"Not Found",0)

 

[DEllis]

Take a look at

Excel VLOOKUP Function Examples and Troubleshoot Problems

Excel VLOOKUP formula examples. Find product price. Change letter grades to numbers. Troubleshoot. Fix sorting problem. Videos, written steps, Excel file

www.contextures.com

Maybe there are extraneous characters, mostly spaces, in one sheet or in both. Check.

Hope this helps

M.

Thank you I cleaned up all extra spaces and it worked. Appreciate your help.

 

[Marcelo Branco]

You are welcome. Thanks for the feedback.

M,