Hi ...

I have this formula, which works fine....

=IF(I1<50000,LOOKUP(I1,{30000,40000},{"0.002","0.0 03"}),IF(I1<100000,LOOKUP(I1,{80000,90000},{"0.002 ","0.003"})))

suppose I would like to replace 30000,40000,80000 and 90000 with actual cell
references, i.e. in Cell A1 = 30000, thus allowing the lookup value to be
dynamic.

Any ideas?

Thanks,

PJS