Lookup Matching Names in Multiple Columns [Closed]

Report
-
 jspgolf -
Hello, I found this site on a google search. Thanks in advance for any help that could possibly be provided.

I'm an IT PM. I currently have spreadsheet - column A consists of 1300 user account names. That's my base. Columns B thru L are individual application groups containing the user account names for each group. So column B could have 600 account names, Column C-2000 account names, D-2400 account names, etc. I think you understand what I'm getting at here.

I need to see if any user account name in column A, exists in any of the columns B thru L. If so, that user cannot be upgraded.

Can anyone tell me how to automate that?

THANK YOU VERY MUCH IN ADVANCE!!

Regards,
Jeff

1 reply

Sorry...email me if you need more detail. I didn't want to bore anyone with detailed specifics.
5
Thank you

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

CCM 2942 users have said thank you to us this month

Subscribe To Our Newsletter!

The Best of CCM in Your Inbox

Subscribe To Our Newsletter!