Combining multiple IFs

[Bazabelle]

Hi,

I am trying to combine the following into 1. So it's a if the first is true, or 2nd is true, or 3rd is true get the information in Sheet 2 - IFNA(VLOOKUP($A2,' Sheet2'!$A:$CW,54,FALSE,"")), else "";

VLOOKUP($A2,'Sheet1'!$A:$CQ,70,FALSE))=""

VLOOKUP($A2,' Sheet1'!$A:$CQ,70,FALSE))="-"

VLOOKUP($A2,' Sheet1'!$A:$CQ,70,FALSE))="Please Select"

Thanks in advance!

 

[ExceLoki]

try this

=IF(OR(VLOOKUP($A2,'Sheet1'!$A:$CQ,70,FALSE)="",VLOOKUP($A2,'Sheet1'!$A:$CQ,70,FALSE)="-",VLOOKUP($A2,'Sheet1'!$A:$CQ,70,FALSE)="Please Select"),IFNA(VLOOKUP($A2,'Sheet2'!$A:$CW,54,FALSE),""),"")

or

=LET(acqlookup,VLOOKUP($A2,'Sheet1'!$A:$CQ,70,FALSE),IF(OR(acqlookup="",acqlookup="-",acqlookup="Please Select"),IFNA(VLOOKUP($A2,'Sheet2'!$A:$CW,54,FALSE,""),""))

 

[Bazabelle]

I am not sure why the formulas you are giving is not working on my side... I have manage in the below way but it is a very long formula...

=IF(IF(IF(IFNA(VLOOKUP($A2,'Sheet1'!$A:$CW,70,FALSE),VLOOKUP($A2,'Sheet2'!$A:$CW,54,FALSE))="-",IFNA(VLOOKUP($A2,'Sheet2'!$A:$CW,54,FALSE),""),IF(IFNA(VLOOKUP($A2,'Sheet1'!$A:$CW,70,FALSE),VLOOKUP($A2,'PSO Data'!$A:$CW,54,FALSE))="",IFNA(VLOOKUP($A2,'Sheet2'!$A:$CW,54,FALSE),""),IF(IFNA(VLOOKUP($A2,'Sheet1'!$A:$CW,70,FALSE),VLOOKUP($A2,'Sheet2'!$A:$CW,54,FALSE))="Please select",IFNA(VLOOKUP($A2,'Sheet2'!$A:$CW,54,FALSE),""),"")))="",IFNA(VLOOKUP($A2,'Sheet2'!$A:$CW,54,FALSE),""),"")=0,"", IF(IF(IFNA(VLOOKUP($A2,'Sheet1'!$A:$CW,70,FALSE),VLOOKUP($A2,'Sheet2'!$A:$CW,54,FALSE))="-",IFNA(VLOOKUP($A2,'Sheet2'!$A:$CW,54,FALSE),""),IF(IFNA(VLOOKUP($A2,'Sheet1'!$A:$CW,70,FALSE),VLOOKUP($A2,'Sheet2'!$A:$CW,54,FALSE))="",IFNA(VLOOKUP($A2,'Sheet2'!$A:$CW,54,FALSE),""),IF(IFNA(VLOOKUP($A2,'Sheet1'!$A:$CW,70,FALSE),VLOOKUP($A2,'Sheet2'!$A:$CW,54,FALSE))="Please select",IFNA(VLOOKUP($A2,'Sheet2'!$A:$CW,54,FALSE),""),"")))="",IFNA(VLOOKUP($A2,'Sheet2'!$A:$CW,54,FALSE),""),""))

 

[snjpverma]

Try if this short version works:

=IF(OR(ISNUMBER(MATCH(IFNA(VLOOKUP($A2,'Sheet1'!$A:$CW,70,FALSE),VLOOKUP($A2,'Sheet2'!$A:$CW,54,FALSE)),{"-","Please select",""},0))),IFNA(VLOOKUP($A2,'Sheet2'!$A:$CW,54,FALSE),""),"")

 

[Bazabelle]

Try if this short version works:

=IF(OR(ISNUMBER(MATCH(IFNA(VLOOKUP($A2,'Sheet1'!$A:$CW,70,FALSE),VLOOKUP($A2,'Sheet2'!$A:$CW,54,FALSE)),{"-","Please select",""},0))),IFNA(VLOOKUP($A2,'Sheet2'!$A:$CW,54,FALSE),""),"")

It returns all cells blank

 

[ExceLoki]

this should be the equivalent of your formula above, just much shorter

=LET(v54l,VLOOKUP($A2,Sheet2!$A:$CW,54,FALSE),v70l,VLOOKUP($A2,Sheet1!$A:$CW,70,FALSE),IF(IF(IF(IFNA(v70l,v54l)="-",IFNA(v54l,""),IF(IFNA(v70l,VLOOKUP($A2,'PSO Data'!$A:$CW,54,FALSE))="",IFNA(v54l,""),IF(IFNA(v70l,v54l)="Please select",IFNA(v54l,""),"")))="",IFNA(v54l,""),"")=0,"",IF(IF(IFNA(v70l,v54l)="-",IFNA(v54l,""),IF(IFNA(v70l,v54l)="",IFNA(v54l,""),IF(IFNA(v70l,v54l)="Please select",IFNA(v54l,""),"")))="",IFNA(v54l,""),"")))