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...
VLOOKUP() Function in Excel
Tutorial: Full explanation of the Vlookup function in Excel, what it is, how to use it, and when yo...
Data Visualization and Summary Trick for Excel - Outlining Data
Tutorial: How to group and outline data in Excel. Simple trick for collapsing large data sets so th...
Excel VBA Course
Excel VBA Course - From Beginner to Expert

200+ Video Lessons
50+ Hours of Video
200+ Excel Guides

Become a master of VBA and Macros in Excel and learn how to automate all of your tasks in Excel with this online course. (No VBA experience required.)

View Course




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.