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