ISBLANK problem

[SD]

Hello Everyone,

I was looking out for some help in my excel sheet.

I have a formula :

=IF(ISERROR(VLOOKUP($D9,HPEQV1!$D:$E,2,0)*VLOOKUP($D9,'base data'!$D:
$IA,J$1,0)-VLOOKUP($A9,Counterfeit!$X:$IA,Calc1!J$1,0)*SUM('base data'!
J9:J12)),"",VLOOKUP($D9,HPEQV1!$D:$E,2,0)*VLOOKUP($D9,'base data'!$D:
$IA,J$1,0)-VLOOKUP($A9,Counterfeit!$X:$IA,Calc1!J$1,0)*SUM('base data'!
J9:J12))

Now this formula obviously gets a number generated. I have put an
iserror to have a blank. Actually what I would like to do is .. where
ever the result is a zero or a blank ... I would like the cell to have
values of the cell thats is on its left . Like just it would take
the same values , do I use ISBLANK with some cell ref , I am tryin to
find out.

Would appreciate any help.

thanks
SD

 

[Tim879]

try replacing the "" in your formula below with the cell reference to
the left of the formula.


as far as the when the result is 0 part.... try this. (notice the IF
stmt on the 3rd line.

=IF(ISERROR(VLOOKUP($D9,HPEQV1!$D:$E,2,0)*VLOOKUP($D9,'base data'!$D:
$IA,J$1,0)-VLOOKUP($A9,Counterfeit!$X:$IA,Calc1!J$1,0)*SUM('base
data'!
J9:J12)),"", if(VLOOKUP($D9,HPEQV1!$D:$E,2,0)*VLOOKUP($D9,'base
data'!$D:
$IA,J$1,0)-VLOOKUP($A9,Counterfeit!$X:$IA,Calc1!J$1,0)*SUM('base
data'!
J9:J12))= 0, 0, VLOOKUP($D9,HPEQV1!$D:$E,2,0)*VLOOKUP($D9,'base data'!
$D:
$IA,J$1,0)-VLOOKUP($A9,Counterfeit!$X:$IA,Calc1!J$1,0)*SUM('base
data'!
J9:J12))