The UK's Leading Professional Training & Business Solutions Provider

Email or CALL NOW on 01952 581550

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!