I'm trying to find duplicate payments from two accounts. Below is a screenshot of the spreadsheet. I'd like the formula to look for matching payments between columns C and F. When a match is found in column F, the formula pulls the associated values of columns A, B and C and places them next to the duplicate payment in column F. The duplicates may be in any row which makes me think I need an array formula.
I copied the desired result into columns G, H and I.
Any help is appreciated! I've also uploaded the spreadsheet.
Kelly
12-24-2015 8-40-18 AM.jpg
Bookmarks