Hi, i basically have two cells labeled x and y, where y is the last value in a separate table unique to the value of x. Therefore to get a value of y for a particular value of x, I need to enter the number is the x cell and press enter to get my y value.

My problem is that I need to make a table of y against x, but I can't do that with the normal method of making a column of x values and dragging the small black square on the corner of the y cell to make excel automatically assign values to each of the x's. The only method I know is to manually enter each x value and record y which is a very time consuming process!

any help will be greatly appreciated!