Excel - Formula to find text string within a range
Posted on 2011-05-04
Not sure if this is trivial and I am just having a mental block, but I need a formula that will identify if a text string exists anywhere within a range, including within a formula in a cell in that range.
Something akin to this (I know that FINDSTRING is not a standard function in excel - this is just to illustrate):
If A1 and B1 contain the following:
A1 = "Bananas"
B1 = If(A1="Apples","Alan","Bob")
then I need the formula to return TRUE (or whatever) to identify that the string "Alan" exists in the range even though, at this point in time, neither A1 nor B1 evaluates to "Alan".
Hope that makes sense, but if not, please post back for clarification.