You might try:-

=IF(ISNA(VLOOKUP(368.59,myrange,2,FALSE)),"0",VLOO KUP(368.59,myrange,2,FALSE))

Mike

"Jennifer" wrote:

Good day, I have a quick question. When using a vertical lookup that looks
at a named table for the returned values, if the item is not present in the
table it returns an N/A. Is there any way to have it return a zero (0) if it
is not present in the table?