can someone advice me on a excel formula (VLOOKUP)

Copper Contributor


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.




3 Replies
best response confirmed by Hans Vogelaar (MVP)


This can be done with a Pivot Table.

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.