G
Gavin Robertson
I need a function which will tell me if A1 (containing a text string) is to
be found anywhere in column B.
{=OR(EXACT("text string",B1:B100))} will do it but {=OR(EXACT(A1,B1:B100))}
won't and it is the latter which I need as A1 can change.
Can anyone help? I expect this is quite easy and I am making it too
complicated!
Best wishes,
Gavin
be found anywhere in column B.
{=OR(EXACT("text string",B1:B100))} will do it but {=OR(EXACT(A1,B1:B100))}
won't and it is the latter which I need as A1 can change.
Can anyone help? I expect this is quite easy and I am making it too
complicated!
Best wishes,
Gavin