Experienced Exceler Needed

[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

 

[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!C137138)-
(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