can someone advice me on a excel formula (VLOOKUP)

[Pat_B2095]

Hi,

I'm struggling to find the right formula in excel.

I have 3 columns: 1 is an amount in euro, 2 is a specified expense and 3 is a period (month).

Now, I would like to make a report in a different TAB showing the total of amount per expense per period.

Anyone?

[#2 · Accepted solution]

@Pat_B2095 

This can be done with a Pivot Table.

[#3]

Vielen Dank@OliverScheurich 

[#4]

For getting month wise total, it is better to use sumif in excel for single criteria, and there are multiple criteria use sumifs in excel. Vlookup formula will not give consolidated value for lookup value. Simply use SUMIFS for displlaying month wise and expense wise data.
Thanks