Help with repeating formula until condition is met

[somedudenamedmichael]

Hey everyone, new guy here, so sorry in advance if the question isn't posed in the clearest of manners.

Anyway, I'm trying to get Table 2 (as shown below) from Table 1, while trying to avoid macros, since I don't comprehend them yet. For the sake of this example let's say the "name" Column is A and "e-mail" Column is B, and the rows follow the same logic.

So basically, I want Table 2's A2 cell, and all following rows, to be filled with the text from Table 1's A column, so long as there is a corresponding e-mail in Table 1's B column, ignoring all Presidents without an e-mail. This repeated testing for that condition should continue through a certain range of Table 1's A column. It should also be noted that all of Table 1's B column cells without an e-mail, are filled with "-".

Then, a similar formula will have to be created for Table 2's "e-mail" (B) column, but I feel like I can get that done when I understand the logic behind what has to be done in the A column.

Once again, sorry for not using XL2BB to make your lives easier, but I ran into an error when trying to use it, and I was in a hurry to post this.

Thanks in advance for the help!

Table 1

name	e-mail
President of Campo de Ourique	thisemailisfictitious@gmail.com
President of Somewhere Else	-
President of Mordor	-
President of Flatland	thisemailisfictitiousaswell@gmail.com

Table 2

name	e-mail
President of Campo de Ourique	thisemailisfictitious@gmail.com
President of Flatland	thisemailisfictitiousaswell@gmail.com

 

[somedudenamedmichael]

So the final solution was @ExceLoki original formula for E2:

=VLOOKUP(D2,A$2:B$5,2,FALSE)

And for D2, either one of the following will do the trick (credit to both @ExceLoki and @Fluff ):

=IFERROR(INDEX(A:A,AGGREGATE(15,6,ROW(A:A)/(B:B<>"-"),ROW(A2))),"")
=IFERROR(INDEX($A$2:$A$1000,AGGREGATE(15,6,(ROW($A$2:$A$1000)-ROW($A$2)+1)/($B$2:$B$1000<>"-"),ROWS(D$2:D2))),"")

 

[Fluff]

Glad we could help & thanks for the feedback.