Tom’s Tutorials For Excel: Doing a Lookup for Last Number or Last Text in a List
Here is how you can look up items in one column, based on the last cell in a different column of that list which contains a number or text.
The formula in cell E2 is
It returns “Black Onyx” because that is what is in cell C15, corresponding to the fact that cell A15 contains the last number (a time, but still a number) in column A of that list.
The formula in cell F2 is
It returns “4:04” because that is what is in cell D14, corresponding to the fact that cell A14 contains the last text item in column A.