I have two excel sheets "January" and "February". They have the same columns but with different values.
Column A in both sheets is the project name, column B is the project status (Active, Cancelled or Completed).
I would like to see how projects have changed status between January and February by creating a column ("Status change") which displays the status of February, only if it differs from the status on that project in January. Note that there may be new projects that are not in the "January" sheet.
Is there a straight-forward formula for this?