Remove "0" from vlookup results

Hi All,

I am currently using a vlookup to display financial information for the year.

I'm using ISNA to remove #N/A when results arent available but I would also like to remove the number "0" when this result is returned as I would like to run an AVERAGE formula for the months with data and obviously the 0 skews this result.

The formula I currently use is:

=IF(ISNA(VLOOKUP(B4,'[2008 Client Portfolio.xls]Sheet1'!$A$5:$S$1319,8,FALSE)),"",VLOOKUP(B4,'[2008 Client Portfolio.xls]Sheet1'!$A$5:$S$1319,8,FALSE))

Thanks for your help

That formula still returns a #N/A im afraid, I actually had a go myself using another IF formula and found that this works:

=IF(IF(ISNA(VLOOKUP(B13,'[2008 Client Portfolio.xls]Sheet1'!$A$5:$S$1319,8,FALSE)),"",VLOOKUP(B13,'[2008 Client Portfolio.xls]Sheet1'!$A$5:$S$1319,8,FALSE))=0,"",IF(ISNA(VLOOKUP(B13,'[2008 Client Portfolio.xls]Sheet1'!$A$5:$S$1319,8,FALSE)),"",VLOOKUP(B13,'[2008 Client Portfolio.xls]Sheet1'!$A$5:$S$1319,8,FALSE)))

Its quite long winded so if anyone has any suggestions on cutting it down that would be appreciated.