Hi guys in excelforum.

My problem is this:

I want to create a list based on a condition. For example, I want one of my cells to ask for X number of years, and so excel will create a list numbering 1 to X in a certain column. If X is 5, excel will then create a list from 1 to 5 in Column A; if X is 10, the list will be from 1 to 10; and so on and so forth. Then another cell (say Y) will require for me to input a certain value which will remain constant for the duration of the list stated in X. If say I want X to be 5, and I want Y to be 100, then column A will list numbers from 1 to 5 and the matching column B will place the value 100.

row-column.png

How can I do this? Thanks in advance.