Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
VLOOKUP won't generate correct response for "inbetween" values
In the following example, the time "13:15" generates the points "65". I want
it to generate the points "60". The formula seems to be connecting the lookup-value S2 (13:15) with the 65 row. I need it to chose the 60 row, because the time 13:15 is not fast enough to belong to the "13:00" group, but fits within the range of "13:01 to 13:45". How can I change the formula so I get the result of "60" points? My formula: =VLOOKUP(S2,'M4'!G2:H13,2) "S2"=13:15 (formatted as [mm]:ss) 'M4'!=the worksheet with the following relevant columns: Col'G' Col'H' Run Points 09:20 100 09:45 95 10:00 90 10:30 85 11:00 80 11:15 75 12:00 70 13:00 65 13:45 60 14:00 55 14:15 50 14:30 45 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
change "true" and "false" to "availble" and "out of stock" | Excel Worksheet Functions | |||
Response to "Can I get a list of names of all the tabs..." | Excel Discussion (Misc queries) | |||
problems with displaying "duplicate vlookup values" in same column | Excel Discussion (Misc queries) | |||
Count occurences of "1"/"0" (or"TRUE"/"FALSE") in a row w. conditions in the next | New Users to Excel | |||
Changing "returned" values from "0" to "blank" | Excel Worksheet Functions |