Check if Value is Present in the give RANGE

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