+ Reply to Thread
Results 1 to 9 of 9

Please help NA error

  1. #1
    Registered User
    Join Date
    09-01-2014
    Location
    Manitowoc
    MS-Off Ver
    2011
    Posts
    11

    Please help NA error

    Hi could someone help me I get a na error with this code

    =IF(B10="","",(B4+LOOKUP(F14,'Customers'!$M$4:$O$13,'Customers'!$O$4:$O$13)))

    I can't figure out how to use isna or put in the function in the above code..
    Please help...

  2. #2
    Forum Contributor
    Join Date
    07-29-2014
    Location
    Oz
    MS-Off Ver
    2010
    Posts
    142

    Re: Please help NA error

    I think you mean:
    =IF(B10="","",(B4+LOOKUP(F14,'Customers'!$M$4:$M$13,'Customers'!$O$4:$O$13)))

    Dan
    Don't forget to ☆ me if I helped you!

  3. #3
    Registered User
    Join Date
    09-01-2014
    Location
    Manitowoc
    MS-Off Ver
    2011
    Posts
    11

    Re: Please help NA error

    Quote Originally Posted by Danerida View Post
    I think you mean:
    =IF(B10="","",(B4+LOOKUP(F14,'Customers'!$M$4:$M$13,'Customers'!$O$4:$O$13)))

    Dan
    I tried it and I get a #Name? error now

  4. #4
    Forum Contributor
    Join Date
    07-29-2014
    Location
    Oz
    MS-Off Ver
    2010
    Posts
    142

    Re: Please help NA error

    Can you post a copy of your spreadsheet for me to look at?

  5. #5
    Registered User
    Join Date
    09-01-2014
    Location
    Manitowoc
    MS-Off Ver
    2011
    Posts
    11

    Re: Please help NA error

    Quote Originally Posted by Danerida View Post
    Can you post a copy of your spreadsheet for me to look at?
    I would rather not as it has alot of personal data in it
    Thanks any ways

  6. #6
    Forum Contributor
    Join Date
    07-29-2014
    Location
    Oz
    MS-Off Ver
    2010
    Posts
    142

    Re: Please help NA error

    This version worked for me:
    Formula: copy to clipboard
    Please Login or Register  to view this content.


    The single quotes are removed (') around the sheet name.
    Dan

  7. #7
    Forum Guru shg's Avatar
    Join Date
    06-20-2007
    Location
    The Great State of Texas
    MS-Off Ver
    2003, 2010
    Posts
    40,673

    Re: Please help NA error

    What happens with

    =IF(B10="", "", B4 + LOOKUP(F14, 'Customers'!$M$4:$O$13))

    If that still results in #N/A, then the smallest value in M4:M13 is larger than F14.
    Entia non sunt multiplicanda sine necessitate

  8. #8
    Registered User
    Join Date
    09-01-2014
    Location
    Manitowoc
    MS-Off Ver
    2011
    Posts
    11

    Re: Please help NA error

    Quote Originally Posted by shg View Post
    What happens with

    =IF(B10="", "", B4 + LOOKUP(F14, 'Customers'!$M$4:$O$13))

    If that still results in #N/A, then the smallest value in M4:M13 is larger than F14.
    =IF(B10="","",(B4+LOOKUP(F14,'Customers'!$M$4:$O$13,'Customers'!$O$4:$O$13)))
    The M$13 you changed is a O not a zero
    I just deleted the reference and it's working now
    Thanks for your help this forum is the best...

  9. #9
    Forum Guru shg's Avatar
    Join Date
    06-20-2007
    Location
    The Great State of Texas
    MS-Off Ver
    2003, 2010
    Posts
    40,673

    Re: Please help NA error

    You're welcome.

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. [SOLVED] Run-tim error -2147467259(80004005): Automation error Unspecidied error
    By mattress58 in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 07-25-2014, 12:12 PM
  2. Excel macro (compile error. syntax error.) error
    By salar_younis in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 01-06-2014, 06:11 AM
  3. Error "run-time Error '1004': General Odbc Error
    By D4WNO77 in forum Access Tables & Databases
    Replies: 2
    Last Post: 07-16-2012, 09:55 AM
  4. Error 75 File/Path access error, sometimes Error 1004
    By smokebreak in forum Excel Programming / VBA / Macros
    Replies: 14
    Last Post: 02-16-2011, 02:35 PM
  5. Error Handling - On Error GoTo doesn't trap error successfully
    By David in forum Excel Programming / VBA / Macros
    Replies: 9
    Last Post: 02-16-2006, 02:10 PM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1