Results 1 to 4 of 4

Doing a YTD sum - vlookup?

Threaded View

  1. #1
    Forum Contributor tangcla's Avatar
    Join Date
    06-04-2008
    Location
    Melbourne, Australia
    MS-Off Ver
    2010
    Posts
    136

    Doing a YTD sum - vlookup?

    I'm trying to do a year to date single-cell reference for a big worksheet based on accounting periods - so this will change each time the sheet is opened.

    (see example)

    So I am current in P2, and I want to do a year-to-date of each of the line items on another sheet. (all items in column A remain static.) What would the best way of doing it be? I tried a vlookup+vlookup+vlookup+vlookup+... but that formula is far too long.
    Attached Files Attached Files

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. vlookup in multiple worksheets
    By gto65l in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 10-25-2011, 01:04 PM
  2. Vlookup using two columns-needs to match the first two column
    By pduubb in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 04-01-2008, 01:21 PM
  3. presenting array lists returned by VLOOKUP in one cell
    By twelsh37 in forum Excel General
    Replies: 2
    Last Post: 12-05-2007, 01:45 PM
  4. VLOOKUP Returns Zeros When Data is Plainly There
    By longfisher in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 06-17-2007, 04:10 PM
  5. Vlookup formulas
    By afathi in forum Excel General
    Replies: 1
    Last Post: 04-23-2007, 11:40 PM

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