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€�