vlookup calc. returns #####

[Todd]

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]

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