Adapting current formula

J

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
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),"")
 
You must log in or register to reply here.
Back
Top