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

Diego Casillas Zaragoza

Hello,

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.

smartsheet.PNG

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

Bassam Khalil

Hi @Diego Casillas Zaragoza 

Hope you are fine, please try the following formula and convert it to a column formula

=IF(ISBLANK(PO@row), "", (VLOOKUP(PO@row, {return blank Lookup}, 2)))