I would like to populate table AC519:ck448 with information from the tables above (AC97:CK259)-
So info from AG99 would go into cell AD275, Ag225 into AD276, etc
I have tried the formula =IFERROR(OFFSET(AG$96,MATCH($AC275,$AB$96:$AB$259,0)+COUNTIF($AC$273:$AC273,$AC24),0),"")
but this doesn't seem to work- does anybody know here im going wrong or maybe suggest something else.
Thanks
So info from AG99 would go into cell AD275, Ag225 into AD276, etc
I have tried the formula =IFERROR(OFFSET(AG$96,MATCH($AC275,$AB$96:$AB$259,0)+COUNTIF($AC$273:$AC273,$AC24),0),"")
but this doesn't seem to work- does anybody know here im going wrong or maybe suggest something else.
Thanks