In-cell LOOKUP

=LOOKUP(B1,{0,1500,2500,4000,6000,10000,15000,2000 0},{0.17,0.153,0.124,0.107,0.94,0.08,0.68,0.064})


Gord Dibben MS Excel MVP

On Wed, 30 Apr 2008 18:11:34 -0700, AJB wrote:

if my table is as follows:

1 - 1499 0.170
1500-2499 0.153
2500-3999 0.124
4000-5999 0.107
6000-9999 0.094
10000-14999 0.080
15000-19999 0.068
20,000 0.064

If my value is 4100, how can vlookup return the value 0.107?

thanks,

Andy