Assume short column is B and long column is A. In C1:
=if(countif($A:$A,$B1),"yes","no")

then drag fill down to the bottom of the short column.

--
Regards,
Tom Ogilvy


"Connie Martin" wrote:

I have two long columns of numbers, one colum much longer than the other
obviously with numbers that don't exist in the other shorter column. I would
like to do a formula in a column beside the shorter one, which will lookup
the numbers in the shorter column to see if they exist in the longer column
and then put YES or NO accordingly beside each number in the shorter column.
Hope that is clear. How do I do this? Connie