Is there a "contains" lookup formula?

[thomasbeard]

Hi, can someone tell me if there is a formula I can use to identify cells with a common feature.
For example if I have the following cell entries:

a
ab
abc
bc
bb

Is there a formula along the lines of <if A1 contains "a" then "x" otherwise "y"> and the first 3 cells will come up with "x". Thanks

Tom

 

[Joe4]

I think you need to be more specific as to what you mean by a common feature. Anything programmed needs to follow tangible rules, so those rules will need to be clearly defined.

 

[erik.van.geit]

Hi,

if the definition is "contains" you might try SEARCH
  A    B        
1 data contains 
2 a             
3 ab   x        
4 abc  x        
5 bc            
6 bb            

Blad1
[Table-It] version 06 by Erik Van Geit

RANGE FORMULA (1st cell)
B2:B6 =IF(ISERROR(SEARCH(A1,A2)),"","x")

[Table-It] version 06 by Erik Van Geit

kind regards,
Erik