How to exclude cells that contains formula from the range of cells in a LOOKUP function

Hello,   I am currently preparing a payment milestone template which also records the last/latest date of payment. I used the this formula to do just that, =LOOKUP (2,1/ (J4:LN4<>"",$J$2:$LN$2)). B...