Not dispay anything in the cell

[kd81]

Hello everyone,

I am using vlookups and I would like excel not to display "#N/A" when it does not find the value. I would like excel to NOT display anything and leave the cell empy.

Also, when there is a division by 0. I would like excel to not dispaly "#DIV/0!" and leave the cell empty.

Thanks in advance.

Kamel

 

[Andrew Poulsom]

You haven't posted your formulas, but here are a couple of examples:

=IF(COUNTIF(A:A,C1),VLOOKUP(C1,A:B,2,FALSE),"")

=IF(B1,A1/B1,"")

 

[kd81]

It works. Thank you!!