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.
2. Sort Dialog Box to get records to top.
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.
4. IF, ISNA and MATCH functions to show “Missing” when book from library shelves is missing.
Compare two columns, Compare 2 columns, Compare 2 lists, compare two lists, compare two lists of items. Match two columns, Match 2 columns.