IF, ISNA, VLOOKUP - Nested

[ArchieV]

I have this formula below which works only on a single IF, ISNA & VLOOKUP statement:

=IF(ISNA(VLOOKUP(G770670,Aircrafts!$A$2:$A$1000,1,FALSE)),"Others","CL650")

However, when I expanded it to use multiple ISNA & VLOOKUP, it doesn't work.

=IF(ISNA(VLOOKUP(G770670,Aircrafts!$A$2:$A$1000,1,FALSE)),"Others","CL650",ISNA(VLOOKUP(G770670,Aircrafts!$B$2:$B$1000,1,FALSE)),"Others","G5000",ISNA(VLOOKUP(G770670,Aircrafts!$C$2:$C$1000,1,FALSE)),"Others","G6000",ISNA(VLOOKUP(G770670,Aircrafts!$D$2:$D$1000,1,FALSE)),"Others","G7000",ISNA(VLOOKUP(G770670,Aircrafts!$E$2:$E$1000,1,FALSE)),"Others","AIRBUS")

Would appreciate any help I can get.

Thanks!

 

[Nine Zero]

try this one out


=IF(ISNA(VLOOKUP(G770670,Aircrafts!$A$2:$A$1000,1,FALSE))=FALSE,"CL650",IF(ISNA(VLOOKUP(G770670,Aircrafts!$B$2:$B$1000,1,FALSE))=FALSE,"G5000",IF(ISNA(VLOOKUP(G770670,Aircrafts!$C$2:$C$1000,1,FALSE))=FALSE,"G6000",IF(ISNA(VLOOKUP(G770670,Aircrafts!$D$2:$D$1000,1,FALSE))=FALSE,"G7000",IF(ISNA(VLOOKUP(G770670,Aircrafts!$E$2:$E$1000,1,FALSE))=FALSE,"AIRBUS","Others")))))

 

[ArchieV]

try this one out


=IF(ISNA(VLOOKUP(G770670,Aircrafts!$A$2:$A$1000,1,FALSE))=FALSE,"CL650",IF(ISNA(VLOOKUP(G770670,Aircrafts!$B$2:$B$1000,1,FALSE))=FALSE,"G5000",IF(ISNA(VLOOKUP(G770670,Aircrafts!$C$2:$C$1000,1,FALSE))=FALSE,"G6000",IF(ISNA(VLOOKUP(G770670,Aircrafts!$D$2:$D$1000,1,FALSE))=FALSE,"G7000",IF(ISNA(VLOOKUP(G770670,Aircrafts!$E$2:$E$1000,1,FALSE))=FALSE,"AIRBUS","Others")))))

Thank you so much for the help Nine Zero.
Appreciate it. If only you live here in Montréal, I will treat you for a dinner!
Again, thanks you!!!!

 

[Nine Zero]

HAHA
No problem,

Just so you are aware of the issue, when nesting IF statements, you need to set the false condition to the following IF statements until your reach your final false condition so for example:

=IF(anything here,if the anything is true,next if statement,if the next one is true,next if statement,if the next one is true,whatever you want if they are all false (in your case "Others"))))