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
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