Formula needed to return value prior time

You have two minor problems with your data. Columns A and D are TEXT that looks like date/time. To convert to date/time:

Select column A. Data/Text to columns/Finish.

Repeat for column D. Then use this formula, dragged down:

=IFERROR(LOOKUP(2,1/(($E$2:$E$22<>"")*($D$2:$D$22<=$A2)),$E$2:$E$22),"")

Like this:

=IFERROR(LOOKUP(2,1/(($D$2:$D$22<=$A2)),$D$2:$D$22),"")

---

If that takes care of your original question, please select "Thread Tools" from the menu link above and mark this thread as SOLVED.

It'd also be appreciated if you were to click the Add Reputation button at the foot of any of the posts of all members who helped you reach a solution.

Originally Posted by Zoelouiseh

Hi,

Thanks for your help.

I believe it was =IFERROR(LOOKUP(2,1/(($D$2:$D$22<=$A2)),$E$2:$E$22),"") that was needed

No... that will return the value column. The dates are in column D??? Or am I missng something (like a brain, perhaps?)