Good Afternoon:
See attachment.
Step One: TWO Cell Exact Match. Seek formula in yellow highlighted cells in Table 1 column A and B items for an exact match to items within Table 2 column I and J.
Step Two: Conditional Lookup. Then enter soonest the time from column K exceeding or equalling column C time but by not more than one minute.
Use the N:7 Cell as I may need to change the time number from time to time.
Enter Zero (0) if there is no match meeting these conditions.
Any way to do this without decending sort, or with standard non array formula?
Thanks
Bookmarks