Results 1 to 7 of 7

Vlookup, Index Match both returning #N/A value not available error

Threaded View

  1. #1
    Registered User
    Join Date
    09-02-2021
    Location
    New Zealand
    MS-Off Ver
    2016
    Posts
    3

    Question Vlookup, Index Match both returning #N/A value not available error

    Hi guys

    I have 2 worksheets in my excel file, the All standards worksheet has a large table of items referenced as AllStandards in it and the Doable sheet has a smaller table of selected data referenced as Doable. In the Doable sheet I was trying to create a system where I can input a specific ID number in the B column and in the C column, a vlookup or index match formula would search over in the All Standards sheet and get the description relating to that ID number. I tried both the formula methods but I keep getting returned a #N/A error as you'll be able to see in the C2 and C3 cell in the Doable sheet. Could someone please help me with this? I have no idea what I'm doing wrong. Thanks
    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. Help with VLOOKUP and INDEX-MATCH not returning all unique values.
    By codemancode in forum Excel Formulas & Functions
    Replies: 7
    Last Post: 08-20-2020, 02:00 PM
  2. [SOLVED] VLOOKUP /Index Match - Returning a value if conditions are met?
    By CrunchData in forum Excel General
    Replies: 13
    Last Post: 07-28-2019, 01:29 PM
  3. [SOLVED] Returning Non-Zero Vlookup/match/index
    By leomiah in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 10-02-2018, 09:02 AM
  4. Index match returning #value error
    By avinash87 in forum Excel General
    Replies: 6
    Last Post: 02-10-2016, 01:52 PM
  5. Index/Match or VLookup returning Multiple Results
    By Stoppeh in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 08-21-2014, 08:31 PM
  6. Replies: 6
    Last Post: 03-01-2014, 11:56 PM
  7. Index/Match - returning #value error
    By jBailey031285 in forum Excel General
    Replies: 7
    Last Post: 03-13-2012, 04:52 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