Forum Discussion
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...
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")