Excel Forum

Hi there,
I need formulas to compare two sheets with customer ID and LD .if it is different ,I need it to place it on Sheet "Check".if it is same ,keep it as it's.

I attach a sample as well.

thanks

..

A2

=IFERROR(INDEX('New Month'!A:A,AGGREGATE(15,6,ROW('New Month'!$A$2:$A$99)/ISNA(MATCH('New Month'!$A$2:$A$99&'New Month'!$B$2:$B$99,'Old Month'!$A$2:$A$99&'Old Month'!$B$2:$B$99,0)),ROWS(A$2:A2))),"")

Norkaz

Thank you