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.

Okay, thanks for the help. I will send the complete workbook with all the links. I am currently using Excel 2010, and the document is saved as an Excel Macro-Enabled Workbook. This is complete and what I am working on. Can't wait to hear back from you.

basically. if on the income query sheet there is more than one query for Number 2 for example i need it to pick it up. So at the moment it only looks at a specific row that so happens to have item 2 in that row, if there are two queries ill have to add a like below that also has the specific number 2 in column A if the first one is cleared by ticking H4, but the second query is still outstanding, I need it to still be a ? on the main schedule?

Chris