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