If I want to check if the value in a single cell (for example: E5) can also be found in a column of cells (for example: the named range "match_list"), I believe I can do this with either of the following two formulas:

=NOT(ISERROR(MATCH(E5,match_list,0)))
=IF(ISNA(VLOOKUP(E5,match_list,1,FALSE)),"FALSE","TRUE")

But is there a way to check to see if every value in a range of cells (for example: E5:AR5) can be found in the "match_list" range? So it would be FALSE if any one of the values in E5-AR5 can't be found in the match_list range, and it would be TRUE only if every one can be found in the match_list range?

Thanks!