I need a formula to return the earliest time where another row in the same column meets or exceeds a min specified value. I've tried multiple attempts at using INDEX-MATCH. But, if a Check Text cell was empty, it would treat the Value text ("") as having met the check and then use that column (which is wrong because no text specified means the time is not valid). So, I tried to have it check for the min value and a lack of "" for Value, but couldn't get that to work either. Thanks for your help!
Check Text yes yes yes yes
Times 11:00 AM 12:00 PM 1:00 PM 2:00 PM 3:00 PM
Value 2 4 8 10
Min Value 6
Returned Time I would like B5 to return 1:00 PM because the first instance greater or equal to 6 in row 3 where row 1 is not empty is at 2:00 PM
EarliestbasedonfirstMinValue.xlsx
Bookmarks