Comparing two columns of names in Excel

Closed
mannsj Posts 1 Registration date Wednesday September 26, 2012 Status Member Last seen September 26, 2012 - Sep 26, 2012 at 07:38 AM
rizvisa1 Posts 4478 Registration date Thursday January 28, 2010 Status Contributor Last seen May 5, 2022 - Oct 9, 2012 at 07:57 PM
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 responses

rizvisa1 Posts 4478 Registration date Thursday January 28, 2010 Status Contributor Last seen May 5, 2022 766
Oct 9, 2012 at 07:57 PM
why would vlookup not work ?

=if (iserror(vlookup call here), "false", true")
2
venkat1926 Posts 1863 Registration date Sunday June 14, 2009 Status Contributor Last seen August 7, 2021 811
Sep 27, 2012 at 07:49 AM
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.
0