Matching text strings

[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

 

[Gavin Robertson]

Many thanks for that, Mike - it works great now!

I thought I was entering an array formula - I pressed
SHIFT+CTRL+ENTER. What I didn't do is press F2 first - what does that
do? In the Help menu it says simply to press SHIFY+CTRL+ENTER.

Best wishes,



Gavin