lookup command

[PJS]

Hi ...

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

=IF(I1<50000,LOOKUP(I1,{30000,40000},{"0.002","0.003"}),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

 

[T. Valko]

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

That's kind of an unusual formula for what it's doing.

You're looking at 2 ranges of numbers:

30,000 to 49,999
80,000 to 99,999

Anything entered in I1 that is not within one of those ranges will return
either an error or FALSE.

So, does that mean the entry in I1 is limited to a number in one of those
two ranges?