PDA

View Full Version : Sleeper: Match or Lookup commands



Tenspeed39355
09-22-2004, 08:36 AM
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:hi:

Anne Troy
09-22-2004, 10:19 AM
Are you looking for a command in VBA?
Or a function/formula?

Tenspeed39355
09-22-2004, 10:59 AM
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
09-22-2004, 04:49 PM
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.