using MATCH function

[controlfreak]

Hi guys,

I want to check if the value in B1 is contained anywhere in column A. Do i use the match function for this?

[Steve0492]

Do you want to know how many times it is contained in column A, just whether it is contained at all, or the location where it is contained?

Steve

[controlfreak]

Steve,

Sorry to be more specific i want it to return the word TRUE if it's anywhere in there and FALSE if it's not

[Steve0492]

Ok consider this:

=IF(COUNTIFS(A:A,B1)<>0,"TRUE","FALSE")

Let me know if that works for you.

Steve

[controlfreak]

You're a star Steve, that's it!!