| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
How to bring up a blank cell
When inserting a formula i get the N/A when the cell is empty or 0, is there
a way i can have it return it blank... Here is the formula im using =INDEX(Sheet1!$C$2:$C$153,MATCH(A3,Sheet1!$B$2:$B$ 153,FALSE),1) Thanks for the Help Lj |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
How to bring up a blank cell
=IF(ISNA(your formula),"",your formula)
"LJ" wrote: When inserting a formula i get the N/A when the cell is empty or 0, is there a way i can have it return it blank... Here is the formula im using =INDEX(Sheet1!$C$2:$C$153,MATCH(A3,Sheet1!$B$2:$B$ 153,FALSE),1) Thanks for the Help Lj |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
How to bring up a blank cell
Wrap it in an IF(ISNA
=IF(ISNA(INDEX(Sheet1!$C$2:$C$153,MATCH(A3,Sheet1! $B$2:$B$153,FALSE),1)),"",INDEX(Sheet1!$C$2:$C$153 ,MATCH(A3,Sheet1!$B$2:$B$153,FALSE),1)) Gord Dibben MS Excel MVP On Wed, 3 Sep 2008 15:29:01 -0700, LJ wrote: When inserting a formula i get the N/A when the cell is empty or 0, is there a way i can have it return it blank... Here is the formula im using =INDEX(Sheet1!$C$2:$C$153,MATCH(A3,Sheet1!$B$2:$B $153,FALSE),1) Thanks for the Help Lj |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Can I click on a cell and bring up an information box? | Excel Worksheet Functions | |||
| bring hyperlinked cell to top of page | Excel Worksheet Functions | |||
| How bring a color on cell from one sheet to another | Excel Discussion (Misc queries) | |||
| How bring a color on cell from one sheet to another | Excel Discussion (Misc queries) | |||
| Find a non-blank cell and bring back text a in same row | Excel Worksheet Functions | |||
Linear Mode
