Survey Results table lookup errors

Hi guys, the support from everyone has been exceptional and has helped me build up a dynamic tool to capture survey results and collate answers even if rows are deleted. This would happen when questions in the survey are considered unimportant/irrelevant.

An offset sumproduct series of functions provides me the total score percentage for the top level categories. There are 5-6 in total and can easily be charted in a radar.

The second step is to maintain the 'dynamic aspect' (being able to delete rows) and lookup the high-level category, and the subsection and return the score for the individual question. This way I can create a chart for each of the 5 top level categories and show the survey score for each answer in the category. Note each question has a maximum score of 5 and are scored 1-5.

I have a few errors looking up values and percentages coming back as 500% with the addition of new columns (in red in attached). Can someone please have a look and help me with the errors. The first sheet is error free, the second sheet is the 'build'.

Note: Charts will be housed on a separate sheet.

Hi, the last argument in the formula is column number. When you insert a new B-column, you will have to adjust column number in formula from 4 to 5:
=INDEX($A$2:$E$108,MATCH($H21,$A$2:$A$108,0),5)