LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 25
Default 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
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
change "true" and "false" to "availble" and "out of stock" inthestands Excel Worksheet Functions 2 July 19th 07 07:05 PM
Response to "Can I get a list of names of all the tabs..." Bob Umlas, Excel MVP Excel Discussion (Misc queries) 0 January 31st 07 09:33 PM
problems with displaying "duplicate vlookup values" in same column p CAST Excel Discussion (Misc queries) 7 August 7th 06 06:24 PM
Count occurences of "1"/"0" (or"TRUE"/"FALSE") in a row w. conditions in the next BCB New Users to Excel 7 May 13th 06 10:02 PM
Changing "returned" values from "0" to "blank" LATATC Excel Worksheet Functions 2 October 20th 05 04:41 PM


All times are GMT +1. The time now is 05:06 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"