Problem:

Creating a formula that will return TRUE if each of the numbers in column H (Numbers to Check) appears at least once in Range A2:C6.
In case any of the numbers are missing, the formula will return FALSE.

Solution:

Using the COUNTIF and AND functions, in an array formula as follows:
{=AND(COUNTIF(A2:C6,E2:E10))}

(To create Array formula: select the cell after typing the formula,press F2 and then press Ctrl+Shift+Enter)