Forum Discussion

lunaaa's avatar
lunaaa
Copper Contributor
Feb 03, 2023

Check if same column on different sheets based on column A

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?

 

excel
Formulas and Functions

1 Reply

  • HansVogelaar's avatar
    HansVogelaar
    MVP
    Feb 03, 2023

    lunaaa 

    If you want Status Change on the February sheet, enter the following formula in row 2:

     

    =IFERROR(IF(XLOOKUP(A2, January!A:A, January!B:B)=B2, "Same", Changed from "&XLOOKUP(A2, January!A:A, January!B:B)), "New")