Results 1 to 3 of 3

vlookup incorrect return

Threaded View

greeng66 vlookup incorrect return 05-14-2010, 05:40 PM
greeng66 Re: vlookup incorrect return 05-17-2010, 11:00 AM
oldchippy Re: vlookup incorrect return 05-14-2010, 06:03 PM
  1. #1
    Registered User
    Join Date
    02-23-2010
    Location
    Leicester, England
    MS-Off Ver
    Excel 2003
    Posts
    23

    vlookup incorrect return

    I have what should be simple excel problem, but its driving me nuts.

    I have 2 columns:

    Year Excess(1000)
    2009 28,700
    2009 5,567
    2008 22,302
    2007 16,000
    2009 2,100
    2008 50,769
    2007 12,934

    Now data would be entered for potentially 5 years of data, but could be multiple enteries for each year, so when I do a vlookup its just pulling one back. I need it to register all the 2009,2008,2007 years etc, with corresponding total, e.g. 2009 should return £36,367.

    Any help much appreciated.
    Last edited by greeng66; 05-14-2010 at 05:53 PM.

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1