Excel Forum
Similar Content
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...
Vlookup Function That Searches The Entire Workbook - UDF
Macro: This UDF is a Vlookup function that searches the entire workbook in Excel. The syntax...
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.