Lookup date if cell meet certain conditions

One way:

=IF(E2="","",INDEX($C$2:$C$25,MATCH(1,INDEX(($A$2:$A$25=A2)*($B$2:$B$25="Field_Origin_Date"),0),0)))

In Prague, you may need to use ; and not , so see the sheet.

NOTE: first, convert your dates to proper dates - they are currently text.

Then, in F2 copied down:

=IF(E2="","",LOOKUP(2,1/(($A$2:$A$25=A2)*(ISNUMBER($C$2:$C$25)=TRUE)),$C$2:$C$25))

You may need to enter this with CTRL+SHIFT+ENTER and change the commas in the formula to semi-colons for your locale.

The quickest way to convert 'em to real dates is:

Select column C. Data/Text to columns/Finish

Then format the result column as date.

You're welcome.

---

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

It would also be very nice if you were to just click the Add Reputation button at the foot of any of the posts of members who helped you reach a solution.