Excel Forum
Similar Content
VBA IF Statement in Excel Macros
Tutorial: IF statements allow you to make decisions in your Macros and VBA in Excel. An IF statement...
Excel VBA Check if a Cell is in a Range
Tutorial: VBA that checks if a cell is in a range, named range, or any kind of range, in Excel. Sec...
Check if Cell is Empty or Not in Excel
Tutorial: How to check if a cell is empty or is not empty in Excel; this tutorial shows you a couple...
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 724: VLOOKUP Check If Quantities Are Equal In Two Lists Show Differences If Not


Download file: http://people.highline.edu/mgirvin/ExcelIsFun.htm
Learn how to check if quantities are the same in two lists and show the differences if not, list the word "equal" if they are the same, and "not in list" if the lookup items is not in list. See the functions MATCH, INSA, VLOOKUP, IF.





Got a Question? Ask it Here in the Forum.