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
|