Originally Posted by GijsKijlstra

A happy and healthy new year to everyone. I have a problem I hope you can help me with.

I have 5 worksheets (2008 Expenses, 2009 Expenses, 2010 Expenses, 2011 Expenses and 2012 Expenses);
each worksheet containing 12 tabs (for 2008 Expenses the tabs are Jan 08, Feb 08, Mar 08 etc.);
Each tab contains in column C the description of the various expenses across rows 2 through 123.
Columns E through AI, the daily expenses, totaled, per row, in column A.
(so e.g. a2 = total i.e. sum(e2:ai2), c2 WAGES (description in words), e2 through ai2 the daily amounts)

In a sixth worksheet (2013 Expenses) I want to include the Monthly Expenses from earlier years, for reference purposes.
Column H lists the description of the various expenses across rows 2 through 123 (same as in the other worksheets);
Column K, per row, I want to show the total of Jan 12, in column L total Jan 11, in M total Jan 10, in N total Jan 09 in O total Jan 08.

In k2 I wanted to show the WAGES for January 2012 and entered =VLOOKUP(H2,'[2012 Expenses.xlsx]Jan 12'!$A$2:$C$123,1,FALSE)
I did get a result, but the figure is wrong.

Can anyone help me to solve this puzzle? Thanks in advance,

Gijs