I have a tab with various data entries. Lret call it Enter tab. In the second
tab (Calculation), I entered Vlookup formula that looks up information in
Enter. Since some of the conditions repeat, I was hoping to use SUM(VLOOKUP)
to add all those that apply in one cell. But it does not work.
Example

Enter tab:
movie $6
dinner $15
movie $10

Calculation tab:
looks up everything for a movie spend. I used SUM(VLOOKUP), but it does not
return $16, just $6.
Anybody can help?
Thank you
Anna