Excel Forum
Similar Content
How to Quickly Find Data Anywhere in Excel
Tutorial: Finding specific records and/or cells is easy when using the Find tool in Excel. It is loc...
Vlookup Partial Match in Excel
Tutorial: Return Vlookup results on partial matches of a cell's contents. You could type the start, ...
AND Function - Check if All Arguments are True
Tutorial: The AND function in Excel checks if every argument you put in it evaluates to TRUE.  If ev...

Excel Magic Trick 635: Find Perfect Match In Column Using IF & AND functions

See how to find a perfect match of 6 successive items using the AND and IF functions in two formulas:
1) Non-array formula
2) Array formula (much shorter and better formula, but requires Ctrl + Shift + Enter).

Got a Question? Ask it Here in the Forum.