Can anyone tell me how to use some logic to return a value from a partial
cell reference? Here is what I have tried, as you can guess they didnt work.
Is there a wild card that could be put before and after in the formula? (That
is what the % was all about in my first attempt.) note column B is where i am
trying to return the value from the formula.

=if(a1=%her%,€�her€�,0) I also tried€¦ =if(a1=€�her€�,€�her€�,0)
A B
1 t-shirt small her black her
2 t-shirt med him black
3 t-shirt med her black her