I've got a lookup function that sometimes will not find any matching values and thus display a zero as the result. Is there a way to format a cell to simply show a blank cell when this happens? Just don't want to see a zero.

Thanks