Ok thanks, I will give this a shot tomorrow.

I am using indirect because I am inserting many cells and shifting the rest
down. I have to match up names but have different address's, so a query will
not work. I started at 90k lines and narrowed it down to 10k rows with
queries. I am turning them green when they match so I know that I have not
missed any.
Thanks again
Joe
"Bob Phillips" wrote:

If you are wanting it to change by row, why bother with INDIRECT?

--

HTH

RP
(remove nothere from the email address if mailing direct)


"Joeb" wrote in message
...
from reading this board I figured out how to use an indirect formula:
here
is mine:
=IF(INDIRECT("B2743")=INDIRECT("C2743"),1,0)

what I need to do is copy this down through row 9902. I want it to change
to row 2748, 2749, 2750 and so on. right now if I try to copy it down it
remains exactly the same (row 2743). Any ideas??

These boards have been very helpful with advanced functions!!!!

Thank you!!