Match or Lookup commands

[Tenspeed39355]

I have two columns of stock symbols that I need to see if the symbols are in both columns. Could someone give me an example of the correct command to use. Thanks
Max

[Anne Troy]

Are you looking for a command in VBA?
Or a function/formula?

[Tenspeed39355]

I am looking for a function/formula. Column A has a list of stock symbols. Column B also
has a list of stock symbols. I want to find out if the symbols in B are also in A and where they are. Thanks for the quick reply
Max

[Zack Barresse]

In, say C1, type ..

=COUNTIF(A:A,B1)>0

.. and copy down as needed. This will give you a TRUE or a FALSE value, True if it is in column A, a False if it is not.