Vlookups with different criteria

[KuraiChikara]

Hello,
Say you have a bill called TRASH in Cell A2 and a total deduction of -$35 in F2
Then you have that bill again "TRASH" in Cell A115 with a different amount -$130 in F115.

The company is the same so that does not change.
However, when I conduct a VLOOKUP
=VLOOKUP(A2,'Excel Export'!$1:$1048576,6,FALSE)

It will find the first TRASH in cell A2 of -$35 but the second TRASH in cell A115 of -$130 doesnt even get reflected. The first amount of -$35 will be seen.

How can I show the different amounts with a Vlookup or am I out of luck and would have to change the search of the look up value?

 

[KuraiChikara]

I found it! I feel so dumb, it's simply a SUMIF. Thank you all for helping!

 

[AhoyNC]

Glad you figured it out. I was going to say from your post#8 it sound like you wanted SUMIF function.