I'm looking for a way to check ten different Named ranges to look for a match
within a another range. If there is a match, print a message as to which
range matched (a possible 4 matches could exist at one time).

=IF(named range 1=A1:A10,"yadda yadda yadda",IF(named range
2=A1:A10,"something something",IF.......to 10.)

Also, when it prints the messages out, how would it place the results?
Would it follow the order in which they are checked?

I'm not sure that I'm going in the right direction here. Any help is
appreciated.....Ben