Hi,

I am a newbie to Excel programming and would like to know asap how t
have on all formulas where I get '#N/A's to the number 0. The proble
with this is that these N/As are screwing up totals and my boss woul
like to put just 0s. Most of the N/As come from most formulas dealin
with VLOOKUP such as this formula:
=VLOOKUP(TRIM($B43&$D43),PLUTCommCatPTDyn,8,0)

Can somebody give me the syntax so that when I get a n/a, it wil
default to 0, otherwise let the formula display the legitamate value i
comes up with. My boss needs this by the end of the day, so any quic
help is really appreciated. Thanks

--
ray50
-----------------------------------------------------------------------
ray500's Profile: http://www.excelforum.com/member.php...fo&userid=3294
View this thread: http://www.excelforum.com/showthread.php?threadid=52768