2 edited body
source | link
=AND(NOT(ISBLANK($A3)),OR(IFERROR(ARRAYFORMULA(VLOOKUP($A3,INDIRECT("MASTER!F5:J"),COLUMN($A$1:$E$1),0)<>$A3:$E3),1)))
  • VLOOKUP to lookup ID(A3) in the master sheet and return the corresponding 5 columns(5 cells).
  • VLOOKUP results are compared against current row's 5 columns(<>A3:E3).
  • IFERROR to return TRUE if lookup fails(suggesting NewData).
  • ISBLANK to ignore blank rows.
  • AND/OR/NOT Self explanatory. Used to combine TRUE/FALSE in a specific way to achieve intended result.
=AND(NOT(ISBLANK($A3)),OR(IFERROR(ARRAYFORMULA(VLOOKUP($A3,INDIRECT("MASTER!F5:J"),COLUMN($A$1:$E$1),0)<>$A3:$E3),1)))
=AND(NOT(ISBLANK($A3)),OR(IFERROR(ARRAYFORMULA(VLOOKUP($A3,INDIRECT("MASTER!F5:J"),COLUMN($A$1:$E$1),0)<>$A3:$E3),1)))
  • VLOOKUP to lookup ID(A3) in the master sheet and return the corresponding 5 columns(5 cells).
  • VLOOKUP results are compared against current row's 5 columns(<>A3:E3).
  • IFERROR to return TRUE if lookup fails(suggesting NewData).
  • ISBLANK to ignore blank rows.
  • AND/OR/NOT Self explanatory. Used to combine TRUE/FALSE in a specific way to achieve intended result.
1
source | link

=AND(NOT(ISBLANK($A3)),OR(IFERROR(ARRAYFORMULA(VLOOKUP($A3,INDIRECT("MASTER!F5:J"),COLUMN($A$1:$E$1),0)<>$A3:$E3),1)))