if then else 'false' error

Hi there,

I am trying to use a large nested if then else statement. See below:

=IF(AND(Variables!$B$6="T75",R3=1),"sawlog",IF(Variables!$B$6="T",IF(OR(V3='6mProps'!$B$2,V3='6mProps'!$C$2,V3='6mProps'!$D$2,V3='6mProps'!$E$2,V3='6mProps'!$F$2,V3='6mProps'!$G$2,V3='6mProps'!$H$2,V3='6mProps'!$I$2),"sawlog",(IF(OR(V3='6mProps'!$J$2,V3='6mProps'!$K$2,V3='6mProps'!$L$2,V3='6mProps'!$M$2,V3='6mProps'!$N$2,V3='6mProps'!$O$2,V3='6mProps'!$P$2,V3='6mProps'!$Q$2,V3='6mProps'!$R$2),"pole",IF(OR(V3=AllProps!$B$2,V3=AllProps!$C$2,V3=AllProps!$D$2,V3=AllProps!$E$2,V3=AllProps!$F$2,V3=AllProps!$G$2,V3=AllProps!$H$2,V3=AllProps!$I$2,V3=AllProps!$J$2,V3=AllProps!$K$2,V3=AllProps!$L$2,V3=AllProps!$M$2),"sawlog",(IF(OR(V3=AllProps!$N$2,V3=AllProps!$O$2,V3=AllProps!$P$2,V3=AllProps!$Q$2,V3=AllProps!$R$2,V3=AllProps!$S$2,V3=AllProps!$T$2,V3=AllProps!$U$2,V3=AllProps!$V$2),"pole","")))))),""))

When Variables!$B$6="T75" and Variables!$B$6="T" it works the way it should, but when Variables!$B$6="H" it returns false. Can someone please help me fix this?

Thank you!

There are instructions at the top of the page explaining how to attach your sample workbook.

You can simply via the OR

=IF(AND(Variables!$B$1="T75",D2=1),"sawlog",IF(Variables!$B$1="T",IFERROR(IF(MATCH(H2,'6mProps'!$B$2:$I$2,0),"sawlog",0),""),""))

based on formula in your posted file (not same as formula in post description).

There is no test for BS1="H" so no idea what results should be.