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