Trying to create an if index match formula of some sort

I'm struggling with a formula and would love some help. I have the following spreadsheet:
Screenshot.jpg

Essentially, I have a column of dates in column H that is each associated with an ID# in column G. The same ID might have multiple dates. The same ID is in column A as well. I want a formula that will allow me to look in A for the ID in G, and for the dates associated in column C, tell me whether any of them are within two weeks before or two weeks after the date in column H.

I can't just do a lookup, because the lookup will stop when it finds the first instance of the ID#, and the relevant date might be the third or fourth. I've tried doing an index, but I'm not sure what to index, since I'm actually looking for whether the date is within the two week period (and that two week period isn't spelled out to index). I'm thinking there's some kind of if clause I can add in, but it's eluding me. Please help!

I've attached an xls with some sample data, only the relevant columns, and the result I'm trying to achieve (F2).

Thanks!

Thanks so much! It's mostly working but not quite. In the sample xls that you posted, it seems to come out correctly, but when I use the formula in my complete xls (with 45k rows), some of the results are giving me Y when there isn't actually an order date 0-14 days after. My xls is formatted the same way, with the columns in the same places, so I didn't need to adjust it except to adjust the row number for the last row of data. The only difference is the quantity of data. Any ideas?

Aha. So that does work. However, when I try to copy it down, I can't copy it with a cntl-shift-enter (or can I?).

A coworker is actually restructuring the data in our reporting system to make this much easier, so I don't actually need the formula above anymore. But I'm curious about this formula because I don't fully understand it. I understand the concepts of index and match, but what does the MIN portion of the formula do? I'd love to be able to replicate this formula (or something like it) in the future if need be, so would love to understand it better.

Thank you so much for all your help!