There's a way to do multi-element MATCH without array formulas just using SUMPRODUCT.
With a helper column:
"Index of Match"
G2 =SUMPRODUCT(--(D2=$A$2:$A$500), --(E2=$B$2:$B$500), --(F2=$C$2:$C$500), ROW($A$2:$A$500))
"Date of Match"
H2 = IF(G2 >0, INDEX($A$2:$A$500, G2), "")
"Account of Match"
I2 = IF(G2 >0, INDEX($B$2:$B$500, G2), "")
"Amount of Match"
J2 = IF(G2 >0, INDEX($C$2:$C$500, G2), "")
Condensing the SUMPRODUCT into the INDEX is complicated though because INDEX defaults to returning the same row as the input cell when you feed it an array position of zero. (I thought it would throw an error you could trap with IFERROR but I guess not).
EDIT:
Wait, should it be checking the date or just the Account name & value? I assumed yes it should, but it looks like NDM's answer went the other way and didn't consider date.
Bookmarks