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
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.
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.
Related:
- Comparing two columns of names in Excel
- Ideogram ai names - Guide
- My contacts list names - Guide
- Display two columns in data validation list but return only one - Guide
- How to count names in excel - Guide
- Gif in excel - Guide
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
Oct 9, 2012 at 07:57 PM
why would vlookup not work ?
=if (iserror(vlookup call here), "false", true")
=if (iserror(vlookup call here), "false", true")
venkat1926
Posts
1863
Registration date
Sunday June 14, 2009
Status
Contributor
Last seen
August 7, 2021
811
Sep 27, 2012 at 07:49 AM
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.
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.
