ADJUSTING FORMULA TO RETURN BLANK instead of False or N/a

[snewsome]

Hopefully I'm at the tail end of working with this formula, but I need help adjusting the below formula to return a blank cell instead of #N/A or "False" which is what the formula is currently doing.

=IF(AND(OR(M5={5,6,9}),(D5="SU")),LEFT(H5,7)&".59010",IF(AND(OR(M5={1,2,3,4,5,6,9}),L5="M"),LEFT(H5,7)&".71020",IF(AND(OR(M5={1,2,3,4,5,6,9}),L5<>"M"),H5&(VLOOKUP(D5,TYPE!B:C,2,FALSE)))))

 

[Drrellik]

=IFERROR(IF(AND(OR(M5={5,6,9}),(D5="SU")),LEFT(H5,7)&".59010",IF(AND(OR(M5={1,2,3,4,5,6,9}),L5="M"),LEFT(H5,7)&".71020",IF(AND(OR(M5={1,2,3,4,5,6,9}),L5<>"M"),H5&(VLOOKUP(D5,TYPE!B:C,2,FALSE))))),"") will eliminate the #n/a

 

[snewsome]

=IFERROR(IF(AND(OR(M5={5,6,9}),(D5="SU")),LEFT(H5,7)&".59010",IF(AND(OR(M5={1,2,3,4,5,6,9}),L5="M"),LEFT(H5,7)&".71020",IF(AND(OR(M5={1,2,3,4,5,6,9}),L5<>"M"),H5&(VLOOKUP(D5,TYPE!B:C,2,FALSE))))),"") will eliminate the #n/a

It's saying too many arguments...

 

[snewsome]

It's saying too many arguments...

Nevermind...it removed the #n/a, but I'm seeing "FALSE" as well. Not sure how to adjust it to not return a FALSE?

 

[Drrellik]

The False you are seeing is part of your OR argument when all the arguments are False it will return a False. I think this will work but it is a bit large. someone I am sure has a shorter way to do it.

=IF(IFERROR(IF(AND(OR(M5={5,6,9}),(D5="SU")),LEFT(H5,7)&".59010",IF(AND(OR(M5={1,2,3,4,5,6,9}),L5="M"),LEFT(H5,7)&".71020",IF(AND(OR(M5={1,2,3,4,5,6,9}),L5<>"M"),H5&(VLOOKUP(D5,type!B:C,2,FALSE))))),"")=FALSE,"",IFERROR(IF(AND(OR(M5={5,6,9}),(D5="SU")),LEFT(H5,7)&".59010",IF(AND(OR(M5={1,2,3,4,5,6,9}),L5="M"),LEFT(H5,7)&".71020",IF(AND(OR(M5={1,2,3,4,5,6,9}),L5<>"M"),H5&(VLOOKUP(D5,type!B:C,2,FALSE))))),""))

 

[snewsome]

The False you are seeing is part of your OR argument when all the arguments are False it will return a False. I think this will work but it is a bit large. someone I am sure has a shorter way to do it.

=IF(IFERROR(IF(AND(OR(M5={5,6,9}),(D5="SU")),LEFT(H5,7)&".59010",IF(AND(OR(M5={1,2,3,4,5,6,9}),L5="M"),LEFT(H5,7)&".71020",IF(AND(OR(M5={1,2,3,4,5,6,9}),L5<>"M"),H5&(VLOOKUP(D5,type!B:C,2,FALSE))))),"")=FALSE,"",IFERROR(IF(AND(OR(M5={5,6,9}),(D5="SU")),LEFT(H5,7)&".59010",IF(AND(OR(M5={1,2,3,4,5,6,9}),L5="M"),LEFT(H5,7)&".71020",IF(AND(OR(M5={1,2,3,4,5,6,9}),L5<>"M"),H5&(VLOOKUP(D5,type!B:C,2,FALSE))))),""))

OMG!! Yep that worked!! I didn't think it would be that convoluted. Thank you Thank you Thank you!!

 

[Drrellik]

your welcome,

thank you for the feedback.