Excel two column compare

John Darby
John Darby used Ask the Experts™
on
Greetings,

I read the post: http://www.experts-exchange.com/questions/28903591/Compare-two-columns-in-Excel-for-string-comparisons.html#a41381690

I have two tables on the same page where I am wanting to compare the first column of two tables (columns B & H) and want to output to column M with value matches. The gist: Table 1 has the users listed my manager wants to target and Table 2 has a larger list of all domain users with various other columns with data about each user. I am essential trying to 'go fish' for the users in the big list.

The purpose of the output is to allow filtered table view (the gi-normous table) showing only the users from the small table.

Thank you!
Comment
Watch Question

Do more with

Expert Office
EXPERT OFFICE® is a registered trademark of EXPERTS EXCHANGE®
Martin LissOlder than dirt
Most Valuable Expert 2017
Distinguished Expert 2018

Commented:
You've posted this same question at least 13 times in the last half hour.
Microsoft Excel Expert
Top Expert 2014
Commented:
john,

please find attached.

you have two tables in worksheet,

small table on the left and big table on the right.

now with the countif formula which is embedded in condtional formatting. it is basically highlighting column of Big table if the value in Big table column H is found in the Column B of Small Table.

hope it helps.
Book1.xlsx

Author

Commented:
Hey folks,

I have had some major system problems...it seems somehow I have posted multiple times. My apologies; working on the issues now :)
HTML5 and CSS3 Fundamentals

Build a website from the ground up by first learning the fundamentals of HTML5 and CSS3, the two popular programming languages used to present content online. HTML deals with fonts, colors, graphics, and hyperlinks, while CSS describes how HTML elements are to be displayed.

Martin LissOlder than dirt
Most Valuable Expert 2017
Distinguished Expert 2018

Commented:
No problem. When I got the multiple notifications I "Requested Attention" so a moderator will clean them up. Or you could delete the others if nobody has responded to them.
Professor JMicrosoft Excel Expert
Top Expert 2014

Commented:
John, i have provided you with a possible solution, please check let me know how it goes.

Author

Commented:
Thank you PJJ! I will look now!

Author

Commented:
Martin, I goto my past questions and I don't see multiples; maybe they have already been force closed?
Martin LissOlder than dirt
Most Valuable Expert 2017
Distinguished Expert 2018

Commented:
Yes, I agree.

Author

Commented:
Thank you, again! You're a life saver!
Professor JMicrosoft Excel Expert
Top Expert 2014

Commented:
You are welcome John.

Do more with

Expert Office
Submit tech questions to Ask the Experts™ at any time to receive solutions, advice, and new ideas from leading industry professionals.

Start 7-Day Free Trial