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.


Using the COUNTIF and AND functions, in an array formula as follows:

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