Excel Forum
Similar Content
Vlookup Function That Searches The Entire Workbook in Excel - UDF
Macro: With this VLOOKUPWORKBOOK function, you will have to power to more quickly and easily ana...
How to use the Vlookup Function in Excel
Tutorial: Full explanation of the Vlookup function in Excel, what it is, how to use it, and when you...
Stop Excel from Changing Numbers to Dates or Anything Else
Tutorial: How to stop Excel from automatically changing numbers into anything other than what you ty...

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.