Try this:

C1: =EXACT(INDEX(A:A,ROW()),INDEX(C:C,ROW()))
Copy that formula down as far as you need

Does that help?
Post back if you have more questions.
--------------------------

Regards,

Ron
Microsoft MVP (Excel)
(XL2003, Win XP)

"soilcon1" wrote in message
...
I am using the EXACT function in column B to compare if information in
column
A is the same as column C on a spreadsheet. If it is not, I am inserting
cells above all the data in column C until I find a match with column A.
What is happening is that the EXACT function seems to stay fixed with it's
original cell in column C. Example:

A1=apple, C1=orange, B1=EXACT(A1,C1) results in FALSE

But, A2=orange and C1=orange, so I insert a cell above the cell in C so
that
it becomes C2. So now:

A2=orange and C2=orange. But the EXACT function in column B in row 2 now
says:

B2=EXACT(A2,C3). C3=banna, so the result if False.

I want the function to remain B2=EXACT(A2,C2), NOT change to C3.

When more data is entered into the rows A and C later, I need to be able
to
fill the EXACT formula down, so I don't think I can use $. I don't want
to
enter the function individually into each cell in column B.

Any ideas?