Ok, I need syntax when I am merging tables.
I need to search a particular field and do some logic against it.
For example, field A1 could say "i have no idea how to code this problem" and I would have to search for a BEGINNING phrase "i have no idea..."
If found, A1 = B1 (a different field).
Could someone post syntax on how to search for a phrase within a field?
Would you use the search?
If so, then what would the if statement look like?