Likely an easy fix - Vlookup with multiple if statements

[Myopic Matt]

Hi,
I have a project spreadsheet wherein I am trying to perform a v look up based on what the status is for a project with the goal to spit out the "time card last submitted date" for only "in progress" projects while stating a text field for projects that are not "in progress". This is created works =IF((E2="in progress"),VLOOKUP(A2,'Projects Data'!$A$3:$AU$251,10,FALSE),"Project Not In Progress") and the formula provides either the time card submission date or "Project Not In Progress"...
MY PROBLEM is some of the projects do not have a time card last submitted date (blank field) so the formula spits out "1/01/1900" for these. I really need the formula for "in progress" projects without a time card last submitted date to be flagged with another text warning.. Any thoughts appreciated! Thank you.

 

[Fluff]

How about

=IF(E2="in progress",IFERROR(1/(1/VLOOKUP(A2,'Projects Data'!$A$3:$AU$251,10,FALSE)),"No date"),"Project Not In Progress")

 

[Myopic Matt]

Thank you Fluff! Really appreciate it!
I played union in College, tough sport and still hope someday the USA will get better
Thank you again!!

 

[Fluff]

You're welcome & thanks for the feedback.

The Eagles will get better once the sport becomes better known, & I think that the powers that be are heading in the right direction in that regard.