| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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? |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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? |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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? |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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? |
|
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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? |
|
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| =IF(ISERROR(SEARCH("insurance",A125,1)),"","*") | Excel Worksheet Functions | |||
| How do I return "leave cell blank" using IF logic. | Excel Worksheet Functions | |||
| embedding "ISERROR" function into an "IF" statement | Excel Worksheet Functions | |||
| Syntax to "OR" 3 "ISERROR" conditions | Excel Worksheet Functions | |||
| Return blank for true "if" statement when charting, not 0 | Charts and Charting in Excel | |||
Linear Mode
