How to highlight deletions from sheet 2 on sheet 1?

[grim72ftm]

I have an Excel spreadsheet.
On Sheet1 I have a vast amount of data (over 7000 rows and up to column AA):
eg
A Code, B Description, C Page, etc etc AA Proposed Deletions (this column is currently blank and I want to highlight from those found in Sheet2),

On Sheet2 I have a list of proposed deletions (500 rows and 3 columns).
A Code, B Description, C Page

How do I make Sheet1 look up the deletion from Sheet2 and highlight them on Sheet1?


I think this is fairly straight forward to do - but I'm rubbish when it comes to formulae so the easiest solution in basic layman terms would be greatly appreciated.

 

[Andrew Poulsom]

Welcome to MrExcel.

Try:

=REPT("DELETE",ISNUMBER(MATCH(1,INDEX((Sheet2!A$2:A$501=A2)*(Sheet2!B$2:B$501=B2)*(Sheet2!C$2:C$501=C2),),FALSE)))

 

[grim72ftm]

Welcome to MrExcel.

Try:

=REPT("DELETE",ISNUMBER(MATCH(1,INDEX((Sheet2!A$2:A$501=A2)*(Sheet2!B$2:B$501=B2)*(Sheet2!C$2:C$501=C2),),FALSE)))

Perfect - thank you very much.