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

amadeushladun

New Member
Joined
Mar 13, 2019
Messages
2
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!
 

Some videos you may like

Excel Facts

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

amadeushladun

New Member
Joined
Mar 13, 2019
Messages
2
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
Joined
Feb 6, 2012
Messages
1,414
Try in B2 copied across to L2

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

Watch MrExcel Video

Forum statistics

Threads
1,109,041
Messages
5,526,417
Members
409,701
Latest member
nitmani

This Week's Hot Topics

Top