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)))))
=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)))))