Experienced Exceler Needed

B

Biff

Hi Dave,

Just a guess here -

The first IF contains this as the logical:

IF(VLOOKUP(A105&"*Total"

The second IF contains this as the logical:

IF(VLOOKUP(A105&"*"&"Total"

You may also want to explicitly test the vlookup for #N/A.

IF(ISNA(VLOOKUP......

or

IF(ISERROR(VLOOKUP......

Biff
 
D

daver676

Thanks for the help Biff! Your advice was right on, except
now, with the INSA in there, once the first VLOOKUP
becomes true, it seems to disregard the rest of the
formula. Here is the new formula:

=DSUM('830ASCII'!$A:$E,'830ASCII'!$D$1,Criteria!C137:D138)-
(IF(ISNA(VLOOKUP(A108&"
*"&"Total",Shipping,2,FALSE)),0,VLOOKUP(A108&"
*"&"Total",Shipping,2,FALSE)+IF(ISNA(VLOOKUP(A108&"-
R"&"*Total",Shipping,2,FALSE)),0,VLOOKUP(A108&"-
R"&"*Total",Shipping,2,FALSE))))

Any ideas?
Thanks
Dave
 
Top