Compare entries on multiple sheets

Bars03

New Member
Joined
May 12, 2015
Messages
18
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
 

Excel Facts

How to calculate loan payments in Excel?
Use the PMT function: =PMT(5%/12,60,-25000) is for a $25,000 loan, 5% annual interest, 60 month loan.
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.

Code:
=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")
 
Upvote 0

Forum statistics

Threads
1,213,536
Messages
6,114,202
Members
448,554
Latest member
Gleisner2

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top