Compare entries on multiple sheets

[Bars03]

Hi

I have a worksheet with the below detail (A Identifier, B Date, C Amount, D Narrative)


Identifier Date Amount Narrative
Bank 06/05/2015 -60 BX15050165427514 9344567 DDR

I need to check a second worksheet to confirm if this entry appears on it (it will be in the same format) and if so populate column E on the first worksheet with a Narrative confirming if it has been found.

I need some code that will look at the entry on worksheet 1 and check the entries on worksheet 2. If an entry exists on worksheet 2 with the same identifier, date, amount and narrative it will populate column E on worksheet 1 with a specified narrative. i.e. checked.

Thanks

 

[Stridhan]

I dont know what Narrative means but this will match columns A:D with sheet2 column A:D and if theres a match i will result in the word Confirmed. Adjust to fit your names and range.

=IF(ISERROR(MATCH(A2&B2&C2&D2,Sheet2!$A$2:$A$20&Sheet2!$B$2:$B$20&Sheet2!$C$2:$C$20&Sheet2!$D$2:$D$20,0)),"","Confirmed")