Help with combining Index Match and VLookup

[stolba]

Hello guys I have data like this
Transaction # Date Particulars Amount
12 1/20/2016 Rohan 58,280
Need to find value based on name transaction number and date
Rohan
12 1/20/2016 Value

I was thinking about vlookups but could not figured out how to do it . I dont want to use array functions as it will slow down my file. I have big data.
Help me with that if possible to do it with index match and vlookup or if you have better ideas would be appreciated

[AliGW]

You could try this:

=SUMPRODUCT(($A$2:$A$13=$G3)*($B$2:$B$13=$H3)*($C$2:$C$13=I$2),$D$2:$D$13)

[Tony Valko]

You could try this:

=SUMPRODUCT(($A$2:$A$13=$G3)*($B$2:$B$13=$H3)*($C$2:$C$13=I$2),$D$2:$D$13)

SUMIFS would be more efficient:

=SUMIFS($D$2:$D$13,$A$2:$A$13,$G3,$B$2:$B$13,$H3,$C$2:$C$13,I$2)

[popipipo]

Or try a pivot table

[stolba]

thank you guys so much , I haven't slept for around 40 hours and my brain stopped working. perfect solutions . thank you

[Tony Valko]

You're welcome. We appreciate the feedback!