I'm using Vlookup which is working great but some cells are going to *** back #N/A which means when I try to sum the row I get #N/A.
Is there a way to return a zero for a null cell instead of #N/A

Here is the Vlookup line

=VLOOKUP(Q82,'Department standard hour list'!$A$2:$D$390,4,FALSE)*P82

Thanks in advance.