Selecting data from a list based on entered values
 

I need to select data from a list based on certain values that I have
entered.

I have a large amount of regression formulae and need to select thier
coefficent values from the list based on the ranges of the input values.

For example, if the input value is between 0 and 10, select list 1; if its
between 10 and 20, select list 2 and so on.

I have been struggling with this for a while and any help would be
appreciated.

Hi
have a look at:
http://www.xldynamic.com/source/xld.Dropdowns.html
and
http://www.contextures.com/xlDataVal02.html

"GrantM" wrote:

I need to select data from a list based on certain values that I have
entered.

I have a large amount of regression formulae and need to select thier
coefficent values from the list based on the ranges of the input values.

For example, if the input value is between 0 and 10, select list 1; if its
between 10 and 20, select list 2 and so on.

I have been struggling with this for a while and any help would be
appreciated.