LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Junior Member
 
Location: Singapore
Posts: 20
Send a message via Skype™ to GijsKijlstra
Default Vlookup doesn't work: results are wrong

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
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Wrong results from MATCH function Imladrian Excel Worksheet Functions 4 April 25th 23 09:02 AM
LOOKUP Function gives wrong results AndreasW Excel Worksheet Functions 4 October 21st 09 12:45 AM
rng.Count ====results wrong value? shiro[_2_] Excel Programming 7 June 20th 08 02:51 AM
VLOOKUP Formula Returns the Wrong Results. Greg Excel Worksheet Functions 3 June 2nd 08 08:11 AM
macro results wrong Joseph Tibiita Charts and Charting in Excel 2 June 30th 05 05:32 PM


All times are GMT +1. The time now is 08:24 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"