Hi
I'm not even sure this is possible so advice would be welcome!

I need to define a y range based on two variable x parameters, x1 an
x2.

To give an example, x values ranging as integers from 4 to 16 are i
column A (A1:A13) on my spreadsheet, corresponding y values in colum
B. I have listed x1 in cell E1 and x2 in cell F1. x1 = 0 and x2 = 1
for this particular example.

If 0<=x<12, I want to define the corresponding y range from column B.
Here it would be the range B1:B8.

Any suggestions

--
Message posted from http://www.ExcelForum.com