True or false not working with if error in zero values

[redwarez]

Please advice why the true or false function not working properly for zero values when i used if error in vlookup. Sample sheet attached for verification.

[RaulSerg]

="0" is text not a number.
while 0 custom formatted as "-" is a number.
That's why your evaluation returns the unexpected (while technically correct) result.

[Crooza]

Probably because you're entering zero as a text value and not a number

remove the inverted commas


change this

Please Login or Register  to view this content.

to this

Please Login or Register  to view this content.

[redwarez]

Thank You issue solved by using below formula..

=IFERROR(VLOOKUP(N:N,J:K,2,0),0)