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