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

##### New Member
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!

### Excel Facts

Repeat Last Command
Pressing F4 adds dollar signs when editing a formula. When not editing, F4 repeats last command.

#### mrshl9898

##### Well-known Member
Like?

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

##### New Member
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

##### Well-known Member
Try in B2 copied across to L2

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

Replies
3
Views
41
Replies
6
Views
41
Replies
6
Views
73
Replies
1
Views
34
Replies
2
Views
77