Formula for if a range of cells contain the text content of another range of cells it says yes or no

[amadeushladun]

I dont even know if it is possible but I need to figure out how to make a formula to check a column of cells if the cells contain all of a text in a range of a certain row. If the column were to contain all the text in that certain row then have a designated cell to say "Yes", and if all the text is not found in that column then say "No".

I cannot find anything that tells me how to do this so any help will be appreciated!

 

[mrshl9898]

Like?

=IF(MATCH("find this string",A:A,0)>0.1,"YES","NO")

 

[amadeushladun]

I think maybe but now it is just saying N/A in the cell but its probably because I am messing something up. what would your exact formula be with these values. The row of cells B1 to L1 to be found in column D8 to D35. So if those eleven cells text are somewhere in any of the 27 cells in any order than it says yes and if not says no. Im sorry I bet what you said in the above formula is correct but I am just really new to it and I don't know where I am going wrong. Thank you so much!

 

[mrshl9898]

Try in B2 copied across to L2

=IF(MATCH(B1,$D$8:$D$35,0)>0.1,"YES","NO")