My situation is this:

"Names" would have a list of names repeated a number of times (variable but is based on the number of items in "Numbers" and can be obtained with a count. I've done this with no problem already using =INDEX(Names!$B$2:$B$400,INT((ROWS($A$7:A11)-1)/COUNTIF(Final$C$2:$C$1000,11000)+1)). The number of items in "Numbers" can vary but if it changes in count the number of repetitions of names in "Names" column also has to change (in this example im using 3 random numbers which means each person is replicated 3 times). So in essence all items in "Numbers" needs to be repeated for all of the names in "Names" and both need to be variable from time to time as other things in the workbook change. I've looked through various forumns with no luck on how to replicate "numbers" for the items in "Names". Any help would be much appreciated.

Names | Numbers | Names | Numbers | |

Bobby | Random1 | Bobby | Random1 | |

Jill | Random2 | Bobby | Random2 | |

Randy | Random3 | Bobby | Random3 | |

Jill | Random1 | |||

Jill | Random2 | |||

Jill | Random3 | |||

Randy | Random1 | |||

Randy | Random2 | |||

Randy | Random3 |

<tbody>

</tbody>