Excel Magic Trick 528: Check Two Lists For Discrepancies MATCH and VLOOKUP functions. See how to check two data sets (lists tables) to see if there are Discrepancies using MATCH and VLOOKUP functions function. See Conditional Formatting TRUE FALSE formulas using ISERROR and comparative operators to highlight records not in list and records that have discrepancies.
Match Two Lists. Match 2 Lists.
Tags: Excel Magic Trick 528: Check Two Lists For Discrepancies MATCH and VLOOKUP functions, Excel, 2007, 2010, check, two, data, sets, lists, tables, to, see, if, there, are, for, Discrepancies, using, records, not, in, list, MATCH, and, VLOOKUP, functions, function, excelisfun, Mike, Gel, Girvin, Highline, Community, College, Match Two Lists, Match 2 Lists