Download Excel File: https://excelisfun.net/files/EMT1596....
Learn how to create a formula to compare two lists. See Two Formulas. One formula to ask question “Is Item in List?”. One formula to ask the question “Is Item NOT in List?”. Learn how to use the MATCH, ISNUMBER and ISNA functions. See a bonus formula that uses the VLOOKUP Function.