Vlookup returning 0

[hofsheep]

I am using a vlookup nested in an iferror function. Not all of the cells to return have values. The ones without values return 0. I would prefer to have simply a blank cell. What is the best way to do this.

 

[Akashwani]

Hi and welcome to MrExcel.

Try =IFERROR(VLOOKUP(**,*******,**,0),"")

The **** represent your lookup value, range and column number.

I hope that helps.

Ak

 

[Jonmo1]

Welcome to the board.

Do you mean that the vlookup finds a match to the lookup value, but the corresponding cell is blank?
That's not really covered by IFerror because it's not actually an error..

You need to test the result of the vlookup within the Iferror.
Something like
=IFERROR(IF(VLOOKUP(...)=0,"",VLOOKUP(...)),"")

 

[Robert Mika]

I am using a vlookup nested in an iferror function. Not all of the cells to return have values. The ones without values return 0. I would prefer to have simply a blank cell. What is the best way to do this.

Use Custom Format:
0;-0;;@