Results 1 to 3 of 3

Thread: Adapting current formula

  1. #1

    Adapting current formula



    Register for a FREE account, and/
    or Log in to avoid these ads!

    I have an equation in cell AR279

    =IFERROR(INDEX(AG274:AN274,MATCH($AD$8,$AG$270:$AN$270,0)),"")

    However i need to change this so that it picks up the number from the previous quarter (i.e the date that is three months earlier)

    So If AD = 25 MAR 14, I would like it to pick up the number from AJ 274 rather than Ak274
    Attached Files Attached Files

  2. #2
    Super Moderator NBVC's Avatar
    Join Date
    May 2011
    Location
    Mississauga, Canada
    Posts
    1,489
    Articles
    0
    Excel Version
    Excel 2016
    Just add -1 to the MATCH() to offset the position by 1..

    e.g.

    =IFERROR(INDEX(AG274:AN274,MATCH($AD$8,$AG$270:$AN$270,0)-1),"")


  3. #3
    Super Moderator Pecoflyer's Avatar
    Join Date
    Oct 2011
    Location
    Brussels Belgium
    Posts
    1,469
    Articles
    0
    Excel Version
    2010 on Xubuntu

Posting Permissions

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