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...
Hello! I use functions like this all the time! It'll sound clunky but each piece is needed and it works great! Formula: IF(AND(ISNUMBER(SEARCH("bob", [cell])), ISNUMBER(SEARCH("bob", [second cell]))),1,0) The last 1 and 0 will be whatever values you want for finding "bob" or not
AnalystNerd but what if it isn't just "bob' in column A? Basically if any word in column A matches column B want to place the '1' in the 3rd column. Bob was just an example.
I appreciate the help.
- Let's make it more complicated still...if it's any word in any position....
