Perhaps this placed in a cell in say, Sheet3,
eg in B1:
=IF(Sheet1!A1="","",IF(Sheet1!A1=Sheet2!A2,1,0))
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---
"Steve" wrote:
Good morning all.

I did a quick search for the answer to my question, unfortuantely I was
unable to find exactly what i was looking for. I know I have done it before i
am just drawing a blank on how to do it now. Below is what I would like to
do, could someone help me convert it to an if statement?

if worksheet 1 a1 = "" then "" otherwise if worksheet 1 a1 = worksheet 2 a2
then 1 otherwise 0.

Thanks in advance for any help you may beable to offer.
Steve