I don't understand what you mean.

=IF(COUNT(MATCH(X1,Y:Y,0)),"Yes","No")

I assume you want to check cells starting in X1. If you copy the formula
down the column then X1 will increment to X2, X3, X4 etc. The column
references will not change.


--
Biff
Microsoft Excel MVP


<Kevin Rudd wrote in message
om.au...
Thanks Biff

However how to I copy it through 7000 lines without cutting and pasting it
and not dragging it down, because although it changes the cell reference
automatically (required) it also moves the reverence column down one cell
each time, (not required) the column reference is the same set of cells
for the whole 7000 reference cells.

thanks



T. Valko wrote:

One way...
13-Nov-09

One way...

=IF(COUNT(MATCH(X1,Y:Y,0)),"Yes","No")

Copy down as needed

--
Biff
Microsoft Excel MVP


<Kevin Rudd wrote in message

Previous Posts In This Thread:

EggHeadCafe - Software Developer Portal of Choice
ASP.NET TraceListener for Debugging
http://www.eggheadcafe.com/tutorials...tener-for.aspx