Adapting current formula

jaspal

New member
Joined
Jul 12, 2013
Messages
10
Reaction score
0
Points
0
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
 

Attachments

  • Help.xls
    354.5 KB · Views: 11

NBVC

Super Moderator
Staff member
Joined
May 20, 2011
Messages
1,518
Reaction score
0
Points
0
Location
Mississauga, Canada
Excel Version(s)
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),"")
 
Top