=IF(OR(LEFT($G39,1)="2",LEFT($G39,1)="3")

You can reduce that to:

=IF(OR(LEFT($G39)={"2","3"})

For the error trap:

=IF(OR(LEFT($G39)={"2","3"}),IF(ISNA(MATCH(LEFT($G 39,6),'MONTH-YTD Balance
Sheet'!$B$8:$B$1000,0)),0,................),"")

You can save some more keystrokes by using a more compact sheet name without
any spaces:

MYTDBal (or something like that)

You can save a few keystrokes by replacing every instance of FALSE with 0.

You could also save some keystrokes by using an intermediate cell to hold:

=LEFT($G39,6)

Instead of repeating it all those times in the formula:

A1: =LEFT($G39,6)

Then, replace every instance of LEFT($G39,6) with $A1.


--
Biff
Microsoft Excel MVP


"Milodie66" wrote in message
...
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))