iserror is showing zero instead of blank

[Zubair]

I have mentioned "" to brink blank if value is not available but result is appearing with Zero please help.

=IF(ISERROR(VLOOKUP($I84,$AC:$AI,A$16,0)=TRUE),"",(VLOOKUP($I84,$AC:$AI,A$16,0)))

 

[JimM]

Haven't tried it but would think this will do what you need

=ISERROR(VLOOKUP($I84,$AC:$AI,A$16,0),"")

 

[etaf]

what are you looking up ?
VLOOKUP($I84,$AC:$AI,A$16,0)=TRUE doesn't make sense to me, as its returning something

Why the IF and IFERROR for 2 formulas exactly the same

=ISERROR(VLOOKUP($I84,$AC:$AI,A$16,0),"")

 

[Fluff]

Are the return values from the formula text or numbers?

 

[Zubair]

Text

 

[Fluff]

Ok, how about

=IFERROR(T(VLOOKUP($I84,$AC:$AI,A$16,0)),"")

 

[Zubair]

Done thanks

 

[Fluff]

Glad we could help & thanks for the feedback.