I have two linked spreadsheets that I have been creating for an event we have coming up. Everything is working with the exception of one column, column T on the Jobs- Town 2019 workbook. I have a formula that works for each of the individual statements/formulas, but I am unable to figure out how to get them to run through all 5 (D-H in Student Recruitment 2019) and return the proper value (example of the return value can be seen in T in Jobs- Town 2019). I have included a side-by-side screen print of both of the spreadsheets below with the columns/rows affected with test information entered in and one of the cells with the working single statement/formula visible. All of the others are the same only referencing the next column and column header. If I am going about this in the wrong direction, I am open to suggestions. The Vlookup of the value of Q3-7 of Jobs-Town 2019, must be part of the solution, as it allows us to link the job to the assigned groups information each year. Anyone that can help me figure out how to get this to work, if possible to do so, we would be very appreciative!!
Click to enlarge
EDIT: Attached .docx file replaced with screenshot by admin
