How to return a blank result when using SUM(VLOOKUP formula??

I am using the following forumla

=SUM(VLOOKUP(B6,'Current Stock'!$A$2:$E$438,{2,3,4},FALSE))

It works but when it finds there is no match it returns #N/A. I tried the following but Excel did not like it.

=IF(ISERROR(SUM(VLOOKUP(B6,'Current Stock'!$A$2:$E$438,{2,3,4},FALSE)),"",SUM(VLOOKUP(B6,'Current Stock'!$A$2:$E$438,{2,3,4},FALSE))

But this doesn't work either. I have also used =IF(ISNA and this doesn't work. I have it working with a different formula

=IF(ISERROR(VLOOKUP(B6,'Current Stock'!A:E,5,FALSE)),"",VLOOKUP(B6,'Current Stock'!A:E,5,FALSE))

This works and returns a blank cell but i just can't get it with the SUM(VLOOKUP?

ANy help will be greatly appreciated

try using
=SUMproduct(iferror(VLOOKUP(B6,'Current Stock'!$A$2:$E$438,{2,3,4},FALSE),0))

this will work in 2007. if using prior version use Saarang's solution

If you are using Excel 2007 or later, try :

Formula:

Please Login or Register  to view this content.

If you are using version prior to Excel 2007, try :

Formula:

Please Login or Register  to view this content.

Apologies Shannon, the nesting of brackets in my 2nd formula was wrong.

Corrrected formula below :

Formula:

Please Login or Register  to view this content.

Can u post a workbook with sample data?