» Checking for the Presence of Specified Values Within a Range

CATEGORY - Excel Array Formulas VERSION - All Microsoft Excel Versions

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))}

Screenshot // Checking for the Presence of Specified Values Within a Range