Thread: vlookup formula
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
AJB AJB is offline
external usenet poster
 
Posts: 40
Default vlookup formula

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