Experienced Exceler Needed

  • Thread starter Thread starter Biff
  • Start date Start date
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
 
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
 
Back
Top