Searching for Different Text in Multiple Cells...
Posted on 2010-09-24
I am trying to come up with a formula that I can paste into 1 column (Column B) to results from Column A in the following fashion, and I can't seem to get it right no matter what I try. I tried using a nested IF statement if a FIND command and that fails to search past the first test, etc.,
I can do this with 1 formula per row, but I have to change the formula to match each criteria, and of course prefer to do it with 1 formula on every row that will search for the text contained within the strings in Column A and return Column B - NOTE that I want to be able to change what I get as a result later if that makes sense.