Thread
:
vlookup formula
View Single Post
#
1
Posted to microsoft.public.excel.misc
AJB
external usenet poster
Posts: 40
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
Reply With Quote
AJB
View Public Profile
Find all posts by AJB