M
Milodie66
I am having a problem placing in an iserror with the following formula. I
have used iserror before to do if functions if(iserror(vlookup)),0,vlookup))
etc... but cannot get it to work with this many functions. I would like the
formula to return a zero if the lookup is not present. I have tried to place
the iserror directly after the if( and complete the rest of the formula with
,0,or(repeat formula). I'm pulling out my hair, which is bad, because I'm
already half bald.
=IF(OR(LEFT($G39,1)="2",LEFT($G39,1)="3"),VLOOKUP(LEFT($G39,6),'MONTH-YTD
Balance Sheet'!$B$8:$P$1000,'MONTH-YTD Balance
Sheet'!$B$4,FALSE)-VLOOKUP(LEFT($G39,6),'MONTH-YTD Balance
Sheet'!$B$8:$P$1000,'MONTH-YTD Balance
Sheet'!$B$3,FALSE),VLOOKUP(LEFT($G39,6),'MONTH-YTD Balance
Sheet'!$B$8:$P$1000,'MONTH-YTD Balance
Sheet'!$B$3,FALSE)-VLOOKUP(LEFT($G39,6),'MONTH-YTD Balance
Sheet'!$B$8:$P$1000,'MONTH-YTD Balance Sheet'!$B$4,FALSE))
have used iserror before to do if functions if(iserror(vlookup)),0,vlookup))
etc... but cannot get it to work with this many functions. I would like the
formula to return a zero if the lookup is not present. I have tried to place
the iserror directly after the if( and complete the rest of the formula with
,0,or(repeat formula). I'm pulling out my hair, which is bad, because I'm
already half bald.
=IF(OR(LEFT($G39,1)="2",LEFT($G39,1)="3"),VLOOKUP(LEFT($G39,6),'MONTH-YTD
Balance Sheet'!$B$8:$P$1000,'MONTH-YTD Balance
Sheet'!$B$4,FALSE)-VLOOKUP(LEFT($G39,6),'MONTH-YTD Balance
Sheet'!$B$8:$P$1000,'MONTH-YTD Balance
Sheet'!$B$3,FALSE),VLOOKUP(LEFT($G39,6),'MONTH-YTD Balance
Sheet'!$B$8:$P$1000,'MONTH-YTD Balance
Sheet'!$B$3,FALSE)-VLOOKUP(LEFT($G39,6),'MONTH-YTD Balance
Sheet'!$B$8:$P$1000,'MONTH-YTD Balance Sheet'!$B$4,FALSE))