Thanks for your reply.

I tried that solution before I posted.

What I did not say is that D2 on Sheet 3
is linked with sheet called Form ie =Form!$D$12
which is the reason I need iserror to get rid of the #value!

I would appreciate any suggestions