Forum Discussion
If/then statements
Looking for a way to put a value into a column if one column is even partially true to another example Column A --bobs cars; Column B --bobs trucks since both have 'bob' in the column want a '1' p...
Is it possible? Yes, and No. It all depends on where the matching string of letters is to be found. On how varied your two columns are going to be.
In the example you give, it's quite simple, since the three characters "bob" are the first three characters in each string, for then this formula works
=IF(FIND(LEFT(A1,3),B1),1,0)
But if the "bob" characters are buried elsewhere in the text, it becomes trickier.
And if your real world issue is far more variable, sometimes with 2 characters matching, sometimes with 4 or 5, all the more elusive.