| 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? |
| 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 | |||
Threaded Mode
