I work in a school and am trying to set up a spreadsheet to track pupil progress for our disadvantaged pupils. The spreadsheet uses various lookups and then lookup tables to retrieve data from a system extract, and to then compare progress against expectations.
I have however come across a problem with a #VALUE error being returned that, despite looking at it for ages, I just don't understand.
Would anyone mind taking a look at the attached anonymised template? Please see column "O" of the "Progress" tab. This formula is copied from columns F,G,I,J,L,M, however for some reason the nested VLOOKUP stops working at col_index_num 17 (whereas it works when the col_index_num is 16 or less). The lookup table_array contains more than 17 columns, so I just don't understand what is going wrong.