PDA

View Full Version : Matching multiple values from different column



Help help
01-17-2017, 01:05 PM
Hi,

I have to find a way how to compare two columns in excel. One column has bunch of text among which I have to check if particular word from the other column appears.
What should be the formula for that? Thank you in advance for your help :)

Table would look something like this:


Column1
Column2
Result


How should I compare it?
it



and check if the
have



words I'm
looking



looking for are
disposal



in the column I have




at disposal

mancubus
01-17-2017, 02:10 PM
welcome to the forum.

assuming your table starts at row 1 (ie, no header row); insert below formula in C1

=IF(COUNTIF($A$1:$A$500,"*"&B1&"*")>0,"Yes","No")

or, European Format

=IF(COUNTIF($A$1:$A$500;"*"&B1&"*")>0;"Yes";"No")

and copy it down to desired row.