Formula returning "0" instead of ""

Question

This is my formula:

=IF(ISERROR(VLOOKUP(B2,ComSet!$A:$B,2,FALSE)),"",VLOOKUP(B2,ComSet!$A:$B,2,FALSE))

Not only does it return a "0", but if I change it to "NoData" from "" it still returns a zero.

If the cell is not blank, it returns the contents of the cell just like it should.

I'm running Office 2013.

Thank you in advance for any help.

Answer 1

Hi,

try this

=IF(ISNA(VLOOKUP(B2,ComSet!$A:$B,2,FALSE))=TRUE,"",VLOOKUP(B2,ComSet!$A:$B,2,FALSE))

Hope it helps you

Answer 2

I entered that exactly and it still returns the Function instead of  a blank.

I used that same fomula on another of the spreadsheets in my book and it still returns a zero instead of a blank.

Answer 3

There is a typo error in the formula of "ediardp", just change it to

=IFERROR(VLOOKUP(B2,ComSet!$A:$B,2,FALSE),"")

Answer 4

Now that brought up another problem I'm having...when I change the formula, it shows the formula and doesn't calculate at all. I press F9, I save, I press Ctl+Shift+Enter and it still doesn't calculate...just shows the formula, complete with "=" at the beginning. Can you help me with that? We thought it might be an Excel bug so installed Excel 2013 from 2010 which I was usuing earlier and it still won't let me update the data in that column.

Answer 5

Hi,

=iferror(VLOOKUP(B2,ComSet!$A:$B,2,FALSE)),"")