Worksheet one has an asset listing from 2005 and worksheet 2 has an asset
listing from 2006. If there is an asset on worksheet one (2005) and not on
worksheet two (2006) then an asset has been disposed. If its vice versa (an
asset in 2006 but not for 2005) its new and if it is on both sheets then it
is current. The assets are identifed by numbers.
Does this help?
Many thanks,
K

"Bob Phillips" wrote:

What's the difference between

A1 on worksheet 2 not equal to A1 on worksheet 1 i.e. new

and

if A1 on worksheet 1 does not equal A1 on worksheet 2 i.e. disposed

they seem the same condition to me.

--
HTH

Bob Phillips

(replace somewhere in email address with gmail if mailing direct)

"K" wrote in message
...
I need a formula to identify if a cell is missing on either worksheet or
if
they are the same. How do you write a formula that states the following:

If A1 on worksheet 2 = A1 on worksheet 1 then "current" if not then "new"
AND if A1 on worksheet 1 does not equal A1 on worksheet 2 then "disposed"