Complicated VLookup Function with =IF(AND(NOT(ISBLANK

Hey, I'm making an automated spreadsheet for some work I'll need to be doing, and the basis of it is there are multiple tabs (though I have only attached one) that feed into the Main Schedule. Basically there are a range of tests to be done on each section and the answers will tick or ? a box in the main schedule, to track everything.

So currently I have made cell I10 on the MainSchedule link that there will be a tick if D4 (Income Queries) has been ticked, a question mark if there is a query been filled in in E4 (Income Queries) and a tick with a green background to show the query was cleared if then as well as this the H2 (Income Queries) has been ticked. The formula is fairly complicated, and there may be an easier way to do this. However there may be a time where there are multiple issues for each item I am testing. So i wanted instead of I10 just looking at row 2 in Income queries, it to find any row that in the A column (Income Queries) that has a 2 in it for example to get a tick in I10, all the items that have a specific reference of 2 will be ticked with no query beside it.

TLDR: Keep all the same formula of what will tick and what will ? and what will tick green, however intead of just picking up a single line that is predetermined for it to look at multiple records if there are for a specific reference and check all of these for the different tests. Thank you.

Chris.