Home |
Search |
Today's Posts |
#1
![]() |
|||
|
|||
![]()
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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Wrong results from MATCH function | Excel Worksheet Functions | |||
LOOKUP Function gives wrong results | Excel Worksheet Functions | |||
rng.Count ====results wrong value? | Excel Programming | |||
VLOOKUP Formula Returns the Wrong Results. | Excel Worksheet Functions | |||
macro results wrong | Charts and Charting in Excel |