+ Reply to Thread
Results 1 to 3 of 3

Help with #DIV/0! error.

  1. #1
    Registered User
    Join Date
    08-17-2013
    Location
    New York City
    MS-Off Ver
    Excel 2007
    Posts
    14

    Help with #DIV/0! error.

    Hi,

    The formula below works well until it encounters the divide by zero issue. I'm off somewhere, can you please assist so that the result shows '0' instead of '#DIV/0'! ?


    =IFERROR(VLOOKUP($A40,'Status Modified_01'!$A$2:$U$479,COLUMN('Status Modified_01'!H22),FALSE),0)/E34

    Thanks

  2. #2
    Forum Expert
    Join Date
    12-15-2009
    Location
    Chicago, IL
    MS-Off Ver
    Microsoft Office 365
    Posts
    3,177

    Re: Help with #DIV/0! error.

    =IFERROR(VLOOKUP($A40,'Status Modified_01'!$A$2:$U$479,COLUMN('Status Modified_01'!H22),FALSE)/E34,0)

  3. #3
    Registered User
    Join Date
    08-17-2013
    Location
    New York City
    MS-Off Ver
    Excel 2007
    Posts
    14

    Re: Help with #DIV/0! error.

    JieJenn, thank you.The above resolved my issue.

+ 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. VBA ERROR: run time error 1004: Application-defined or Object-defined error in excel 2013
    By AnanthKrishna in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 02-13-2015, 06:16 AM
  2. [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
  3. 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
  4. Receiving following error “Complie error : syntax error” Help
    By masond3 in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 11-02-2012, 10:19 AM
  5. 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
  6. 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
  7. 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