Results 1 to 6 of 6

Subtract year then lookup a value

Threaded View

  1. #1
    Registered User
    Join Date
    05-05-2014
    Location
    Voorheesville, NY
    MS-Off Ver
    Excel 2007
    Posts
    77

    Subtract year then lookup a value

    Hello,
    I need help with a formula. The attached excel workbook contains two worksheet. The “Data II” contains receipt amounts.
    I used this formula to copy the amount for a specific year and it’s working properly
    IFERROR(VLOOKUP(A4,'Data II'!A:E,2,FALSE),"Receipts")

    Here’s the problem:
    What am trying to do is, subtract 1 year out of “A19” for 1998. Then lookup for the cumulative receipt for that year in “Data II) column C…and here’s the formula.
    IFERROR(VLOOKUP(YEAR(A19-1),'Data II'!C:E,3,FALSE),"Cumulative")

    Thank you for your time and consideration.
    Cheryl
    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. [SOLVED] Subtract 1 year from todays date
    By Nigel in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 10-03-2013, 05:46 PM
  2. [SOLVED] Multiple lookup adding columns, then multiplying, then lookup, add, and subtract
    By mamig in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 09-08-2013, 12:55 AM
  3. how to subtract a year from date
    By amartino44 in forum Excel General
    Replies: 3
    Last Post: 08-30-2013, 05:00 PM
  4. [SOLVED] subtract year and divide
    By crystal in forum Excel Formulas & Functions
    Replies: 7
    Last Post: 10-25-2005, 08:05 PM
  5. HOW TO SUBTRACT A YEAR+MONTH AND SHOW DIF IN MONTHS?
    By noles fan in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 10-01-2005, 01:05 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