i have the following in cell D2:
"=IF(C2<C4,D4,IF(C2<C5,D5,IF(C2<C6,D6,IF(C2<C7,D7, IF(C2<C8,D8,D9)))))"

basically, in C2 is a value; column B from row 4 down has the lower bracket
and column C from row 4 down has the upper bracket; Column D will have
another value that will calculate back into D2. ex:

MIN MAX RESULT
0 100 28
101 200 25
201 300 22
301 18

and so forth..., if C2 has a value of 223, D2 would show 22. the problem is
sometimes the min and max values will change and the amount of brackets will
also increase or decrease depending on different years, etc.

i need a macro that will autopopulate cell D2 - if possible;

thanx