| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
LOOKUP FUNCTION? (LOOKUP VALUE BEING A TIME RENERATED FROM A FORMU
The lookup value I'm using is from the following string.
=IF(C32<10,TIME((B32-(H24-J33)),0,0),(J33-TIME(H24,0,0))) The result of this string is being displayed as the correct time (4:00) but referencing it as a lookup value (=LOOKUP(J24,A8:A31,C8:C31) the result being displayed for the lookup function is the value for 3:00 not 4:00. I have a column renerating the times (the same basic string of functions) and 10 out of 12 lookup results are off by one hour? Only 9:00 and 11:00 are returning the correct values. All the cells are formated the same as well? Anyone have any ideas? Thanks, Jerry |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Lookup function one row at a time | Excel Worksheet Functions | |||
| Join 2 Lists - Lookup value in 1 list & use result in 2nd lookup | Excel Worksheet Functions | |||
| Lookup function with condition in time series data | Excel Worksheet Functions | |||
| time lookup | New Users to Excel | |||
| Pivot table doing a lookup without using the lookup function? | Excel Discussion (Misc queries) | |||
Threaded Mode
