Tip Printed from ExcelTip.com

---

Checking for the Presence of Specified Values within a Range


Problem:

Creating a formula that will return TRUE if each number in column E appears at least once in the range A2:C6.
If any of the specified numbers are missing, the formula will return FALSE.

Solution:

Use AND and COUNTIF functions in the following Array formula:
{=AND(COUNTIF(A2:C6,E2:E10))}