Repeat a range of values starting at a specifc value without using vba

Question

Using only the formula's provided by excel what i want to do is create a repeating list of values starting from a inputted value that exists in the range.

for example:

In this example I have a list of 4 names, and when someone enters one of the names in the input box in D1 a list of repeating values will appear in the D column starting with "Bob".

I'm not that skilled in using Excel formula's so I'm wondering if this is even possible without using vba

Answer 1

In D2, use:

=IF(INDEX(A:A,MATCH(D1,A:A,0)+1)="",A$2,INDEX(A:A,MATCH(D1,A:A,0)+1))

Then copy down.