Formula to get all matching values and return all occurrences of match in order based on 1st occurrence of a value in another column

Question

This one is interesting and I am not even sure if it can be done with a formula. I can do it with a macro but I want a formula for this one.

I have 2 sets of data. The 1st set contains some dates and a true/false field and an ID number. The 2nd set of data contains some dates and ID number and a blank column. Now I need to find the 1st occurrence of an ID number in the 2nd dataset and then based on that check the 1st dataset for matching numbers and then check if value is false in the 3rd column. If that value is false return date from 2nd column.

Now I can go this on my own with a vlookup if I only wanted the 1st occurrence but I need to get all matches. The dates in the 2nd column can be ignored they are not part of the formula.

Here is an example of what the data should look like after applying the formula. I need the false dates to be returned. I know I can build this as a function but I really need to do a formula if possible.

Update:

I did find JOINTEXT() however that does not work in excel 2013 :| so that is out of the question.

Answer 1

You can use INDEX and AGGREGATE combination:

=IFERROR(INDEX(B:B,AGGREGATE(15,6,ROW(A:A)/((G2=A:A)*(0=--(C:C))),COUNTIF($G$2:G2,G2))),"")

In my example in column C are boolean values. If you have text there then change part of formula (0=--(C:C)) to ("FALSE"=C:C)