Hi,

Am Sun, 20 Nov 2016 02:52:36 +0000 schrieb coreyk88:

Column A Column B Column C Column H
Date Amount ($) Transaction Type (x,p,or f)
12/17 100.00 Payment x
12/19 (45.00) Purchase f
12/22 (55.00) Interest f
12/27 (38.55) Purchase p

What I am trying to do is return the Column H value based on the closest
match (not necessarily exact) in column A AND an exact match in Column C
of "Payment".. If Column A has an exact match but is not also "Payment"
in Column C, it should find the next closest (previous) result that
definitely has "Payment" in Column C.

the expected date in K1, the transaction type in L1.
Then try for a date +/- 3 days:
=INDEX(H:H,SUMPRODUCT(--(A2:A10=K1-3),--(A2:A10<=K1+3),--(C2:C10=L1),ROW(2:10)))



Regards
Claus B.
--
Windows10
Office 2016