Hello,

My problem is such. I have column values in a second worksheet that I am manipulating in the first worksheet. I am also using the find function, so this is what I ideally wish would work

=if(find("b", secondsheet!a2), "Found B", "Found C")

Unfortunately, the false part isn't printing and is giving me a !value error. I tried using ifs and ors but it isn't working. Help appreciated.