Hi, could you please help me I need to find a formula :
Let’s say we have text in all of the following cells (but in cell B1 we only have one word) :
A1 B1 C1
A2
A3
A4
A5
I would like to know what’s the formula to find :
If the word in cell B1 appears in one of the cell of A1:A5 (but each cell from A1 to A5 contain more than one word) then if it’s true = C1
I hope it's clear enough
Thanks in advance
Let’s say we have text in all of the following cells (but in cell B1 we only have one word) :
A1 B1 C1
A2
A3
A4
A5
I would like to know what’s the formula to find :
If the word in cell B1 appears in one of the cell of A1:A5 (but each cell from A1 to A5 contain more than one word) then if it’s true = C1
I hope it's clear enough
Thanks in advance