Excel Forum



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.





Got a Question? Ask it Here in the Forum.