Iserror - can it return a "blank" value?

S

smartgal

I have the following formula:

=IF(ISERROR(VLOOKUP(A5,Input!A:B,2,0)),"",VLOOKUP(A5,Input!A:B,2,0))

If I don't have an entry in my "input" sheet, it returns a value of "0."
What I *want* it to do is to not show anything if there's no entry. Can I
just make it look blank?
 
T

T. Valko

You have to nest another lookup testing for blank:

=IF(ISERROR(VLOOKUP(A5,Input!A:B,2,0)),"",IF(VLOOKUP(A5,Input!A:B,2,0)="","",VLOOKUP(A5,Input!A:B,2,0)))
 
S

smartgal

Never mind, just conditionally formatted so that if the value is "0" the text
is white . . .
 
S

smartgal

Oooh, I like it! I'll try it. Thanks!

T. Valko said:
You have to nest another lookup testing for blank:

=IF(ISERROR(VLOOKUP(A5,Input!A:B,2,0)),"",IF(VLOOKUP(A5,Input!A:B,2,0)="","",VLOOKUP(A5,Input!A:B,2,0)))
 
T

T. Valko

Yeah, that's another alternative as long as the "hidden" 0 doesn't mess up
any downstream calculations.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top