Results 1 to 16 of 16

VLOOKUP #N/A Error

Threaded View

  1. #1
    Registered User
    Join Date
    06-18-2016
    Location
    Charlotte, NC
    MS-Off Ver
    MS 365
    Posts
    30

    VLOOKUP #N/A Error

    Hi all. I am at my wit's end trying to figure out this error. I am building a scoring template for another test. There is an input sheet for demographic information and Raw Time in Seconds. The Raw Time in Seconds provides T-scores based on the examinee's age. The T-Scores and Percentile Ranks are populated on the Score Sheet along with Composite scores. The data on this page is populated from the raw scores on the Input page and data on the Trails page (Trails page will eventually be hidden). The problem that I am having is on the Profile page. That page provides Normative Frequencies and is populated from data on the Score Sheet, the Composite Index Sheet, and the Normative Data Sheet. The Composite Index Sheet and the Normative Data Sheet will eventually be hidden as well. The problem that I'm having is the "Normative Frequency of the Difference" column under the Ipsative Comparisons of Trails section. Sometimes it works; sometimes it doesn't. The Normative Frequency of the Difference column is populated by the "T Score Minus Mean" value. However, the table only does positive numbers so I calculate the absolute value on the Normative Data sheet and use the table array there. The formula varies based on the trail number, but Trail 1 is =VLOOKUP('Normative Data!'I46,'Normative Data!'A55:F164,2,FALSE). Trails 2, 3, 4, and 5 are column 3, 4, 5, and 6 respectively.

    As stated, sometimes it works and sometimes it doesn't. However, only Trail 1 and 5 work depending on the values. I've tested with multiple "Raw Time in Seconds" combinations and it varies based on that. Any help would be appreciated. I've scoured the forum, YouTube, and Google but nothing has worked.
    Attached Files Attached Files

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Replies: 1
    Last Post: 12-08-2020, 05:16 AM
  2. [SOLVED] Vlookup Error - unable to get the vlookup property of the worksheetfunction class
    By forrestgump1980 in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 03-14-2019, 02:59 PM
  3. [SOLVED] application vlookup error runtime error 1004, unable to get the vlookup property of the.."
    By dmcgov in forum Excel Programming / VBA / Macros
    Replies: 23
    Last Post: 12-05-2018, 12:03 PM
  4. Concatenate error across 2 worksheets with vlookup error
    By COGICPENNY in forum Excel General
    Replies: 2
    Last Post: 11-30-2015, 07:56 PM
  5. Iferror vlookup if error vlookup if x=Y,
    By rwmeis in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 11-21-2013, 08:24 PM
  6. How to error trap a vlookup that returns an error or #N/A
    By kjy1989 in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 06-06-2013, 12:01 PM
  7. [SOLVED] lookup - if(is error(vlookup and error messages meanings
    By grphillips in forum Excel Formulas & Functions
    Replies: 8
    Last Post: 03-18-2013, 07:03 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