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
Check out the Formula Handbook template!