Lookup Matching Names in Multiple Columns

Question

Lookup Matching Names in Multiple Columns

[Closed]

Report

jspgolf - Aug 13, 2009 at 04:12 PM
jspgolf - Aug 13, 2009 at 04:18 PM

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

How to match names in excel where spelling differ
Excel match names in two columns ✓ - Forum - Excel
Comparing dates in multiple columns and using one that matches ✓ - Forum - Excel
Excel data validation list from table multiple columns - How-To - Excel
Perform a Partial Cell Match in Excel - How-To - Excel
Excel vba delete multiple columns based on header ✓ - Forum - Excel

1 reply

Ask a question

jspgolf · Accepted Answer · 2009-08-13T16:18:49-0400

Answer 1 / 1

jspgolf
Aug 13, 2009 at 04:18 PM

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

Lookup Matching Names in Multiple Columns

1 reply

Your reply

Subscribe To Our Newsletter!