title: Repeat a range of values starting at a specifc value without using vba
body: <p>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.</p>
  
  <p>for example:</p>
  
  <p><a href="https://i.stack.imgur.com/AEfoE.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/AEfoE.png" alt="enter image description here"></a></p>
  
  <p>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".</p>
  
  <p>I'm not that skilled in using Excel formula's so I'm wondering if this is even possible without using vba</p>