Match, Search or Index? :S

[denby]

Hi Guys


i have 2 columns, one is description and the other is manufacturer

i would like to see if the first word in column b matches collums c
if it does i need it to put "true" in column D, or false if the first word is not Columns C's value


please see below image
EXCEL.png

can anyone help me with the formula for this?

sorry if this is a little unclear
thanks

[Pete_UK]

Try this in D1:

=IF(ISNA(SEARCH(C1,B1)),FALSE,SEARCH(C1,B1)=1)

then copy down.

Hope this helps.

Pete

[bebo021999]

May be:

=NOT(ISERROR(SEARCH(C1,B1)=1))

Replace SEARCH with FIND in case-sensitive case