Multi-Match lookup Formula w/specific Text Output

Hello, if someone could help me with this that would be so awesome.

This array formula will:

1) Check the date (C4)
2) Find first matching date in "Table6[SIM/ZONE Due Dates]"
3) Display Items listed in the same row in Table6[Model]

This formula is duplicated down the column but offset to find the next corresponding item in the data list with the same Due Date that matches the date in C4. So it will give me a full list of all the items that have the same date in C4.

Goal:

-Do the same thing but in column C in the example Weekly Summary sheet, but instead I want it to display "Yes" or "No" if the Info for that row exist.

Formula:

{=IFERROR(INDEX(Table6[Model], SMALL(IF('Weekly Summary'!C4=Table6[SIM/ZONE Due Date], ROW(Table6[SIM/ZONE Due Date])-MIN(ROW(Table6[SIM/ZONE Due Date]))+1, ""), ROW('Master Tracker'!A1)))&" SIMULATIONS", "")}


Any help would be awesome, thank you.

Example:

Example1.xlsx

Try this (If I understood your needs correctly??)

Attached!

Your post does not comply with Rule 1 of our Forum RULES. Your post title should accurately and concisely describe your problem, not your anticipated solution.

Use terms appropriate to a Google search. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will be addressed according to the OP's experience in the forum: If you have less than 10 posts, expect (and respond to) a request to change your thread title. If you have 10 or more posts, expect your post to be locked, so you can start a new thread with an appropriate title.

To change a Title on your post, click EDIT then Go Advanced and change your title, if 2 days have passed ask a moderator to do it for you.

(This thread should receive no further responses until this moderation request is fulfilled, as per Forum Rule 7)

Hi,

I'm afraid I'm over my head with this one? I still do not really understand what you need. You may need to rely on other forumla gurus to assist with this one. I have set up a non array formula, but I was merely playing around trying to conceptualize what you needed and manipulating the formula to try and get there... I doubt its practical for your needs.

Anyways, I have attached the workbook nevertheless.