index / indirect giving #ref

Hi All,

so i am using the following formula...
=IF(P15A1C="TRUE","\"&ROUND(INDEX(INDIRECT($C5),DG$2,1),2),"")

which matches up to this :
=IFERROR(MATCH(DG3,Room_Mix,0),"-")

in DG3 it has 5A1C

I have used this formula for the first 31 cells and it has worked fine... using the same formula just changing the row number for the index and obviously the match cell to pull what i want.

However once i get past 31 it just returns #REF however i am using the EXACT same format and formulas for the first 31..

If i change the match in DG3 to one of the previous 31 it pulls through that correct value so i know it isnt the formula as such, but im not sure what it could be?


Any ideas?

ignore this post, i found out what it was.. lol