records change

  • Thread starter Thread starter DD
  • Start date Start date
D

DD

how to keep track the changes of the records.

Eg, my sheet1 i have this record,

client name client address
lee blk 323
loo blk 456

sheet 2

client name client address
lee blk 888
loo blk 456

how can i use the IF formula to detect the change of the client address eg
for this scenario is client name lee address has been changed to blk 888 ?
 
One way...

Entered on Sheet1 cell C2 then copied down as needed:

=IF(COUNT(MATCH(A2,Sheet2!A$2:A$20,0)),IF(VLOOKUP(A2,Sheet2!A$2:B$20,2,0)=B2,"same","change"),"not
found")
 
Hi,

In 2003 - this detects wheather there is a match for both name and address
on the second sheet.

=IF(SUMPRODUCT(--(A2=Sheet3!A$2:A$11),--(Sheet3!B$2:B$11=B2)),"same","changed")

In 2007:

=IF(COUNTIFS(Sheet3!A$2:A$11,A2,Sheet3!B$2:B$11,B2),"Same","Changed")
 
Back
Top