Sorry I never explained it very clear at all.

I am using the if function which works well,

=if(a2=sheet1!a3,"yes","")

but when i copy and paste it becomes

=if(a3=sheet1!a4,"yes","")

How do I get the Sheet1 value to stay static?

Hope that it easier to understand.

Thanks

Greg