Mike, Thank you! I had a problem with the parentheses, and it now works.

"Mike H" wrote:

Maybe this

=IF(ISNA(VLOOKUP(C1,A1:B6,2,FALSE)),"",VLOOKUP(C1, A1:B6,2,FALSE))

Mike

"C" wrote:

I have a VLookup which is returning #N/A, how can I have the formula return a
zero "0" in its place? I need to sum and the sheet is very large. Thanks for
any help.