On 8 mar, 23:03, Shaun wrote:
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 didn’t 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

Good evening

You can try the Excel FIND function like this
IF(ISERROR(FIND("her";A1;1));0;"her")
The FIND function returns an Error (#VALUE!) if the substring "her" is
not found.

Regards