Iserror - can it return a "blank" value?
 

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?

Iserror - can it return a "blank" value?
 

You have to nest another lookup testing for blank:

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

--
Biff
Microsoft Excel MVP


"smartgal" wrote in message
...
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?

Iserror - can it return a "blank" value?
 

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

"smartgal" wrote:

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?

Iserror - can it return a "blank" value?
 

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

"T. Valko" wrote:

You have to nest another lookup testing for blank:

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

--
Biff
Microsoft Excel MVP


"smartgal" wrote in message
...
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?

Iserror - can it return a "blank" value?
 

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

--
Biff
Microsoft Excel MVP


"smartgal" wrote in message
...
Never mind, just conditionally formatted so that if the value is "0" the
text
is white . . .

"smartgal" wrote:

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?

Iserror - can it return a "blank" value?
 

One mo
=if(iserror(1/len(vlookup(...)),"",vlookup(...))

smartgal wrote:

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?

--

Dave Peterson