Combining 2 ISNA formulas

[MARKEGANDERSON]

Hello All - I am having issues combining the below:

=IF(ISNA(MATCH(H11,FIT,0)),"",IF(ISNA(MATCH(H7,PFT,0)),$W$1,""))

They work fine without the combination:

=IF(ISNA(MATCH(H7,PFT,0)),"",$W$1)

=IF(ISNA(MATCH(H11,FIT,0)),"",$W$1)

How can i combine both?

 

[Fluff]

How about

=IF(AND(ISNA(MATCH(H11,FIT,0)),ISNA(MATCH(H7,pft,0))),"",$W$1)

 

[Phuoc]

Or try:

=IF(COUNT(MATCH(H11,FIT,0),MATCH(H7,PFT,0)),$W$1,"")

 

[MARKEGANDERSON]

How about

=IF(AND(ISNA(MATCH(H11,FIT,0)),ISNA(MATCH(H7,pft,0))),"",$W$1)

Thanks! This one worked.

 

[MARKEGANDERSON]

Or try:

=IF(COUNT(MATCH(H11,FIT,0),MATCH(H7,PFT,0)),$W$1,"")

Thanks! This one also worked.

 

[Fluff]

Glad we could help & thanks for the feedback.

 

[Alex Blakenburg]

Just to clarify, Fluff is using AND logic and both need to be NA to return "". Phuoc's version is the equivalent of changing the AND in Fluff's to an OR so only one needs to be NA to return "" (it also treats having H7 & H11 both blank differently)