And all your formulae like this:

IFERROR(OFFSET(INDEX(N1:N200,MAT.....

where there are no $ signs before the numbers (e.g. N$1:N$200), have you manually typed those in dozens and dozens of times? Do you know what th e$ signs are for?