Searching for a specific value on a specific date

[gcaulfield88]

Hello,

I've been wondering if Excel can do this for a while...

Basically, I'm trying to match certain transactions between two bank accounts, where the only like values are going to be date and disbursement/deposit amount. Obviously vlookup will not work here because there are many duplicate values. In the attachment I put in a Vlookup in the Account 2 tab to try and demonstrate what I'm trying to do exactly, which is match deposits in Account 2 with Disbursements in Account 1.

After looking around I found that maybe a combination of INDEX/MATCH would work here but could not figure out how to get it to work or even if it is appropriate in this situation. Any help would be greatly appreciated. Thank you.

[6StringJazzer]

What do you need back from the formula? Just whether a match exists? If so this can be done with COUNTIFS. This shows the number of matching transactions (I presume this will normally be 0 or 1). Put this formula in E5 and copy down:

Please Login or Register  to view this content.