In the USA version, I could modify my formula:
=if(iserror(vlookup(...)),"",vlookup(...))

Another option may be to convert your formulas to values and then use the
equivalent of Edit|Replace to change those #n/d's to nothing.



Galamdring wrote:

Thank god for this forum... :)

I was having the same problems and the solution presented above worked
wonderfully.

But i have a question...

I am making a table that will then be copy-pasted into another excel
worksheet. Is there a way to remove those annoying #N/D error marks
whenever VLOOKUP doesn't find a value?

PS: In the english version the error may not be called #N/D... I am
using a Portuguese version (VLOOKUP = PROCV)

Thanks in advance... :)

--
Galamdring
------------------------------------------------------------------------
Galamdring's Profile: http://www.excelforum.com/member.php...o&userid=25459
View this thread: http://www.excelforum.com/showthread...hreadid=391479

--

Dave Peterson