Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
convert vlookup formula to link formula | Excel Worksheet Functions | |||
VLOOKUP formula | Excel Discussion (Misc queries) | |||
Help with IF(VLOOKUP) formula | Excel Discussion (Misc queries) | |||
Excel 2002 VLOOKUP formula or other formula | Excel Discussion (Misc queries) | |||
vlookup formula | Excel Discussion (Misc queries) |