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.