Excel Compare Two Lists Formula: Item In List? Item Not In List?

Topics: Lookup Formulas, a few Statistics functions, Goal Seek

Topics in this video:
1. Is Item In List 2 also in List 1? Use MATCH and ISNUMBER. Comparing a prospective customer sales phone list to the companies master customer list (00:27 min)
2. Sort Dialog Box to get records to top (02:43 min)
3. Is Item in List 2 NOT in List 1? Use MATCH and ISNA. Comparing Library database list of books to the list of items found in inventory count. (03:36 min)
4. IF, ISNA and MATCH functions to show “Missing” when book from library shelves is missing (05:20 min)

Compare two columns, Compare 2 columns, Compare 2 lists, compare two lists, compare two lists of items. Match two columns, Match 2 columns.