vlookup calc. returns #####

Todd · Apr 7, 2004

How do I get a formula with a vlookup to return Zero, not
##### if the answer is negative?

=VLOOKUP(B56,C10:J802,8,FALSE)-TIME(8,0,0)

Thanks,

Todd

Frank Kabel · Apr 7, 2004

Hi
try
=MAX(VLOOKUP(B56,C10:J802,8,FALSE)-TIME(8,0,0),0)