Results 1 to 11 of 11

Unable to resolve #N/A error

Threaded View

  1. 06-07-2023, 12:10 AM #1
    davism2
    davism2 is offline
    Registered User
    Join Date
    11-18-2004
    Location
    San Jose, CA
    MS-Off Ver
    Windows 2010 with Office Suite 2016
    Posts
    10

    Unable to resolve #N/A error

    Functions attempted: VLOOKUP, XLOOKUP, INDEX and IFS

    COL D looks up the value in the adjacent cell in COL C.
    VLOOKUP in D enters value in array PtsPCT (N8-O48).

    COL C and N8-N48 are formatted as Numbers
    COL D and O8-O48 are formatted as Percentiles

    All functions attempted resulted with a #N/A error. This is especially maddening as other VLOOKUP, XLOOKUP, INDEX and IFS functions I've used in other sheets have worked perfect today.
    Attached Files Attached Files
    Last edited by davism2; 06-07-2023 at 12:17 AM.
    Reply With QuoteRegister To Reply
« Previous Thread | Next Thread »

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Unable to resolve timeout in Power Query
    By dtrom26 in forum Excel General
    Replies: 6
    Last Post: 11-28-2019, 11:35 AM
  2. how to resolve blank error
    By Merrysa in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 08-12-2019, 09:32 AM
  3. [SOLVED] unable to resolve error 424
    By rickmeister in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 04-28-2017, 04:46 PM
  4. Unable to resolve a formula with blank cells
    By JennyMedley in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 04-27-2017, 09:28 PM
  5. unable to resolve a #NUM! error message
    By Bill369 in forum Excel Formulas & Functions
    Replies: 6
    Last Post: 11-11-2015, 07:12 PM
  6. [SOLVED] Unable to resolve #DIV/0! in sumproduct function
    By ruraljur0r in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 03-23-2014, 09:57 AM
  7. Unable to resolve Runtime error 91
    By jr2007 in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 04-18-2013, 07:37 AM

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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1