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

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

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