Help me figure out IFNA and VLOOKUP functions to find matching table values based on multiple conditions.

[CaliGxddx]

Hello, Forum Friends!

I have a workbook consisting of several tabs with tables and a summary page.

On the summary page, I have the following IF statement that returns the correct data.

=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"))

BUT, I am not getting the result that I want with the IFNA function, I can’t wrap my head around what I am leaving out…

I am stuck getting the following results: if cell “26” AA = “Yes”, lookup D4 in table18, cell “29” AD= “I want to pull the date in cell AD if cell AA =yes”, if cell AA=”No”, ”Task Not Baselined”, empty=No data.

Any assistance with this would be greatly appreciated.

Thank you in advance.

 

[Chrisdontm]

For IFNA you start the formula off with it...for instance;

=IFNA( insert your whole formula here , after a comma enter the results you want in case it is NA then close parentheses)

 

[CaliGxddx]

Thank you for responding. Please explain in greater detail. I cannot discern what you are instructing me to do.

 

[Chrisdontm]

About your formula, When you wanted to use IFNA, it looks like you are saying, " If the first "IF" formula is true, then put "N/A", then you went into an IFNA formula.
What it looks like should be done is if the first part is true, then don't put "N/A" just put the formula you want if it is true. At the end of all of that, if all else fails, leave the cell blank, which is what I believe you mean by " No Data "... (But if you want, we can put the words " No Data " )
So try this, and tell me if this is what you are looking for;

=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)),IF(T4="N","Need Key Task",IF(VLOOKUP(D4,Table18[#All],26,FALSE)="Yes",VLOOKUP(D4,Table18[#All],29,FALSE),IF(VLOOKUP(D4,Table18[#All],26,FALSE)="No","Task Not Baselined",""))),"")

Now if I don't have this quite right, we can figure it out, it just takes time between work hours...

{As for what I was telling you to do, when you use an " IFNA " formula, then you put it at the beginning, which says, " If my formula results in "N/A", then put this as the answer at the end...which you have as "No Data" }