How can i pull a range of values in to a column based on a cell value

[nickwh34]

Hi All

I have attached a simple spread sheet what i am trying to do is lookup a value for example the weekly payments 3 or 7 and pull across the corresponding payment dates. So if the value in the cell is 3 i want to be able to pull the payment date for weeks 1 to 3 into the column payment due date. Basically the person enters the bill date and then the value owed what i want to be able to do automatically is calculate the payment dates based on the number of weekly payments available.

Any help would be greatly appreciated, trying to use the v lookup but someone here has a easier way.

Many Thanks