| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Lookup to Show Empty Cell
Okay, I have my lookup to zero but now realize that in the future that will
mess up my averages if a person actually gets a zero. So how can I get this to just show an empty cell as that doesn't appear to impact the averages like a zero will. =IF(ISNA(VLOOKUP($B4, '3-25'!$A$2:$C$51,2,0)),0,VLOOKUP($B4, '3-25'!$A$2:$C$51,2,0)) Thank you |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| using a vlookup, can i use isblank to show an empty cell | Excel Worksheet Functions | |||
| Show a blank result in a cell when there is no value in the "Lookup" cell | New Users to Excel | |||
| show 0.00 if referenced cell is empty | Excel Worksheet Functions | |||
| Using if function to show blank when cell in other sheet is empty | Excel Worksheet Functions | |||
| Need cells to show as zero or empty | Excel Worksheet Functions | |||
Threaded Mode
