Hi,

I am a newbie to Excel programming and would like to know asap how to have on all formulas where I get '#N/A's to the number 0. The problem with this is that these N/As are screwing up totals and my boss would like to put just 0s. Most of the N/As come from most formulas dealing 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 will default to 0, otherwise let the formula display the legitamate value is comes up with. My boss needs this by the end of the day, so any quick help is really appreciated. Thanks.