Spreadsheet: 218058d1362324756-lookup-function-two-fixed-and-one-conditional-matches-three-condition-lookup-03032013
Sheet: Sheet1

Lookup function with three conditions.  Two are fixed and the third is variable and conditioned.
Thanks for all the help with this query.  Getting closer for sure.
General Objective: Examine the times in column C.  Search for the time in column J that equals or exceeds the C column time, but which is also less than the value in M1 plus the C column time, and which also has an exact match in the A, B and H, I columns. The formula is to be placed in column E at cell E17 downward.
Update: The formula has been pasted to and copied to E17:E33.  The formula works as long as there are no column A and B duplications in Table 1.  I apparently had no column A, B, H & I duplications in the original file.  It appears that Column H and I duplications impact the results too, but only if there is a greater time value.  (Copy the contents of L22:M22 to H22.  The change results in a Zero value in cell E21.  The lower time value at J30 does not impact the E21 result standing alone).
The two table below have been modified to create duplications A and B duplications in Table 1 and H & I duplications in Table 2.  The fill colors visually direct the viewer to the matching desired answers.  If the reconcile column (F) is greater than zero, then there is an error.
Table 1 |  |  |  |  |  |  | Table 2 |  |  |  |  | Time Condition
Asset | Location | Time | Manual Result | [NAME] | Reconcile |  | Asset | Location | Time |  |  | 00:01:00
B-12 | Baldwin | 2013-02-26 08:51:33 | 2013-02-26 08:51:55 |  |  |  | B | BB | 2013-02-15 10:32:53
I | CC | 2013-02-15 14:22:00 | 00:00:00 |  |  |  | B-12 | Baldwin | 2013-02-26 08:51:55
H | BB | 2013-02-15 08:45:00 | 00:00:00 |  |  |  | B | BB | 2013-02-15 08:00:52
F | CC | 2013-02-15 10:34:00 | 00:00:00 |  |  |  | C | CC | 2013-02-15 08:27:11
B-14 | Baldwin | 2013-02-26 14:46:14 | 2013-02-26 14:46:32 |  |  |  | C | CC | 2013-02-15 10:32:53
D | AA | 2013-02-15 15:49:00 | 2013-02-15 15:49:02 |  |  |  | D | AA | 2013-02-15 15:49:02 |  | B-14 | Baldwin
V-100 | Baldwin | 2013-02-26 10:43:28 | 2013-02-26 10:43:46 |  |  |  | D | Baldwin | 2013-02-26 10:43:46
B | BB | 2013-02-15 10:32:00 | 2013-02-15 10:32:53 |  |  |  | V-100 | Baldwin | 2013-02-15 08:26:50
A | AA | 2013-02-15 09:02:00 | 00:00:00 |  |  |  | F | CC | 2013-02-15 08:06:45
 |  | 2013-02-15 08:32:00 | 00:00:00 |  |  |  | V-100 | Baldwin | 2013-02-15 09:02:45
C | CC | 2013-02-15 08:27:00 | 2013-02-15 08:27:11 |  |  |  | B-14 | Baldwin | 2013-02-26 14:46:32
C | CC | 2013-02-15 10:32:00 | 2013-02-15 10:32:53 |  |  |  | H | BB | 2013-02-15 08:41:42
F | BB | 2013-02-15 11:32:00 | 00:00:00 |  |  |  | V-100 | Baldwin | 2013-02-15 09:02:28
 |  | 2013-02-15 08:11:30 | 2013-02-15 08:12:29 |  |  |  | B-14 | Baldwin | 2013-02-15 08:30:17
V-100 | Baldwin | 2013-02-15 09:02:26 | 2013-02-15 09:02:28 |  |  |  | J | AA | 2013-02-15 08:29:39
J | AA | 2013-02-15 08:29:39 | 2013-02-15 08:29:39 |  |  |  | J | AA | 2013-02-15 08:19:26
H | AA | 2013-02-15 08:29:39 | 00:00:00 |  |  |  | V-100 | Baldwin | 2013-02-26 10:43:46
 |  |  |  |  |  |  | V-100 | Baldwin | 2013-02-15 15:49:01
 |  |  |  |  |  |  |  |  | 2013-02-15 08:12:29