Good Morning, Excel Forum World.
See the attached file.
Step One: TWO Cell Exact Match. Seek formula in yellow highlighted cells in Table 1 seeking exact match of column A and B items to items within Table 2 column H and I.
Step Two: Conditional Lookup. Enter soonest time from column J exceeding or equalling the column C time but by not more than the time entered in cell M:16.
Enter Zero (0) if there is no match meeting these conditions.
NOTE: The formula entered in the E column answers a different question. It asks whether the matching number is the next higher number and enters 0 if it is not the next higher number, apparently ignoring the two cell exact match condition. Example: See cell E:22. The desired answer number for E:22 is in D:22, entered manually. However, the number in J:34 is causing the formula answer to be ZERO, because the desired number is the second number greater than the c:22 number and even though the two matching conditions are not met.
Any way to do this without decending or ascending sort, or with standard non array formula?
Thanks so very much
Bookmarks