Trouble looking up a text and bringing back something if a value is >= a specific date

[MR22]

Good Morning - I have been trying all kinds of formulas (search, find, match, vlookup, etc.) and I am just not getting back what I want to see. so Picture column A has a list of 1,000's of names (some multiple times). Column C has a date. In column F I have removed the duplicates and have all of the names listed only once. Next to those names, I want to find that name in the list of thousands everytime it appears and if Column C in any of those cases is > or = a date I am looking at in a certain cell then I want it to bring back a 1. If the date is not then I want it to bring back blank "". I know how to do the if statement perfectly and I can throw a vlook-up in the middle but unfortunately I am off a bit because vlookup only locates the first time the name would be in the list and maybe the 2nd time it's in the list it has a date that is > or = to the one I am looking for so should be pulling back the "1" that I want to see.

Please let me know if this is too confusing but really am just looking for the middle of the if formula that will help me look at the name in the list and the date that goes with it to be able to complete my if statement.

Thank you all in advance!!

MR22

[Glenn Kennedy]

Will you please attach a SMALL sample Excel workbook (10-20 rows of data is usually enough)? Please don't attach a picture of one (no-one will want to re-type all your stuff before starting).

1. Make sure that your sample data are truly REPRESENTATIVE of your real data. The use of unrepresentative data is very frustrating and can lead to long delays in reaching a solution.

2. Make sure that your desired solution is also shown (mock up the results manually).

3. Make sure that all confidential information is removed first!!

4. Try to avoid using merged cells. They cause lots of problems!

Unfortunately the attachment icon doesn't work at the moment. So, to attach an Excel file you have to do the following: Just before posting, scroll down to Go Advanced and then scroll down to Manage Attachments. Now follow the instructions at the top of that screen.

[MR22]

Thank you. Added attachment.

[Glenn Kennedy]

In K10, copied down:
=IFERROR(INDEX($A$10:$A$17,MATCH(0,INDEX(COUNTIF($K$9:$K9,$A$10:$A$17),0),0)),"")

In J10, copied down:
=IF(SUMPRODUCT(($A$10:$A$17=K10)*($C$10:$C$17>=$C$7))>0,1,"")

[MR22]

Thank you!!!

[Glenn Kennedy]

You're welcome.

---

If that takes care of your original question, please select "Thread Tools" from the menu link above and mark this thread as SOLVED.

It'd also be appreciated if you were to click the Add Reputation button at the foot of any of the posts of all members who helped you reach a solution.