I would like to have the (#N/A) caculations appear a (0) within the following formula. =VLOOKUP(A2,'RUNNING DATA wkly'!AO$3:AR$6000,4,0)