Hello!
I'm trying to set a formula that if cell B5 has text, then it activates the VLOOKUP on a database on another sheet, however, I'm trying to get that if the cell on the database is blank it does not show 0.
So far I got this formula:
=IF(ISTEXT(B4),VLOOKUP(B4,Sheet2!A4:H11001,7,FALSE),"")
However I'm not sure how to make sure that it doesn't show a 0.
Does anybody know how to get it to not show a 0 if it is blank?
Thanks!
I'm trying to set a formula that if cell B5 has text, then it activates the VLOOKUP on a database on another sheet, however, I'm trying to get that if the cell on the database is blank it does not show 0.
So far I got this formula:
=IF(ISTEXT(B4),VLOOKUP(B4,Sheet2!A4:H11001,7,FALSE),"")
However I'm not sure how to make sure that it doesn't show a 0.
Does anybody know how to get it to not show a 0 if it is blank?
Thanks!