Hi,

I am working on a spreadsheet and on my pc the following formula shows
blank or the vlookup value:
=IF(ISERROR(VLOOKUP(B11,SKUMap!$A$1:$F$766,3,FALSE )),"",(VLOOKUP(B11,SKUMap!$A$1:$F$766,3,FALSE)))

I went to my client's pc and instead of blank it shows zeros. I even
tried changing the formula to display a dash (-) instead of blank but
it still gave me zeros. It does display the vlookup value correctly.

I have Excel 2002. I unfortunately didn't get the version he has.

I can't seem to recreate it in my version of Excel.

Could this be a setting under Options in Excel?

Thank you,

Terry