Comparing two columns of names in Excel

[Closed]
Report
Posts
1
Registration date
Wednesday September 26, 2012
Status
Member
Last seen
September 26, 2012
-
Posts
4476
Registration date
Thursday January 28, 2010
Status
Contributor
Last seen
August 2, 2020
-
Hello, I need some help with an Excel formula. I have a column of user names and a column of usernames intermixed with non-user names.

I would like to have usernames in column a, the mixed list in column b and then a formula in column c that would display yes/no or true/false if the name exists in both columns. I have attempted a couple of IF formulas and VLOOKUP with out getting the results I was looking for. Does anyone have any ideas for me??

Thanks for any and all assistance.


2 replies

Posts
4476
Registration date
Thursday January 28, 2010
Status
Contributor
Last seen
August 2, 2020
768
why would vlookup not work ?

=if (iserror(vlookup call here), "false", true")
2
Thank you

A few words of thanks would be greatly appreciated. Add comment

CCM 2821 users have said thank you to us this month

Posts
1864
Registration date
Sunday June 14, 2009
Status
Contributor
Last seen
August 7, 2021
803
inforamtion not complete . how is the entry user name and non user name is configusred.

for e.g.venkat,venkqweat.kenvrty ryv
in the combined name is charcters of name are together like venkatqwe or dispersed vebnkay or in any ordear.