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
Bookmarks