Dear All. I am with a bit of a problem and for a while now I have floundered and cannot find a solution. So, I've attached a worksheet that explains exactly what I want to accomplish. Please suggest best solution, best practice the formula in cell V is not functioning properly.
=IF(OR(D4="TBD",N4="No",F4="No data",AND(F4="Concept",L4<=$L$1),AND(F4="Definition",L4<=$L$1),AND(F4="Agile Planning",L4<=$L$1)),"N/A",IFNA(IF(T4="N", "Need Key Task",IF(VLOOKUP(D4,Table18[#All],26,FALSE)="Yes",VLOOKUP(D4,Table18[#All],29,FALSE),"Task Not Baselined")),"No data"))
Thank you in advance!
~Thayle
=IF(OR(D4="TBD",N4="No",F4="No data",AND(F4="Concept",L4<=$L$1),AND(F4="Definition",L4<=$L$1),AND(F4="Agile Planning",L4<=$L$1)),"N/A",IFNA(IF(T4="N", "Need Key Task",IF(VLOOKUP(D4,Table18[#All],26,FALSE)="Yes",VLOOKUP(D4,Table18[#All],29,FALSE),"Task Not Baselined")),"No data"))
Thank you in advance!
~Thayle