Some formulas break when Lookup data is moved?

[CWatsonJr]

This is really puzzling me.

I Have attached a sheet where the formulas work but if cells AC1:AE10 are moved down a row (shift-delete / cntrl-v) the formulas (in U3:AA10) break. I am really puzzled why only those cells break and the rest (the cells below those in u:aa) don't... actually, I'm puzzled why they break in the first place.

This is a very small sample of the actual data being used and number of rows changes year to year.

Thank you in advance for your assistance.