How to make the return blank if nothing is entered on column


I have my formulas working when I input information to pull from another sheet. The problem is if I deleted the lookup value, the return columns do not go blank. They either return some random numbers or #nomatch.

I have tried =IFERROR at the beginning of my formula as well as , 0 or , FALSE at the end and nothing is working. I just want the rest of the columns to be blank if the lookup column is blank as well.

The blank cells return B00989 SEMSYS-PJ-ECH2 9T if I delete the PO value


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!