Nesting Excel Formula – MATCH, ISNA and IF to find which items are missing from a list

Here’s a video I’ve recorded for our delegates who have completed Excel Level 3 Gurus course. It shows how to ‘nest’ 3 formulas to find if an item appears in a different list. That’s a useful thing to be able to do, so I take you step by step through how to build the formula. Try it yourself!