IF Formula that looks at a list

[carl]

I have a list of products in column K..

All products sold are in column A. I would like to put a
formula into column B that will return true if the product
in column A (in that row) is on the list in column K.

Thank you in advance.

 

[Dave R.]

=ISNUMBER(MATCH(A1,K1:K9999,0))

or

=ISNUMBER(MATCH(A1,K:K,0))

if you want all of K.

 

[Frank Kabel]

Hi
try
=COUNTIF($K:$K,A1)>0