Forum Discussion

Copper Contributor

Mar 03, 2022

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...

Formulas and Functions

AnalystNerd

Copper Contributor

Mar 03, 2022

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

david1776
Copper Contributor
Mar 03, 2022
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.
- mathetes
  Silver Contributor
  Mar 03, 2022
  david1776
  
  Since you're adding complications as we go along, how about giving a much more complete picture here of what you're dealing with. How many words max? What's the bigger picture into which this little task fits?
- mathetes
  Silver Contributor
  Mar 03, 2022
  Let's make it more complicated still...if it's any word in any position....