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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Help With VLOOKUP 2
conditional formatting 6
Use & with two formulas 2
The code below worked for a few days and just totally stoppedworking. 1
vlookup returns na 7
vlookups and logical statements? 0
IF, ISNA & VLOOKUP 5
Temp vaiables in formulas? 2

Back
Top