+ Reply to Thread
Results 1 to 8 of 8

Index formula showing N/A or Value when data is present

  1. #1
    Forum Contributor
    Join Date
    02-07-2016
    Location
    England
    MS-Off Ver
    2019
    Posts
    270

    Index formula showing N/A or Value when data is present

    I have Index formulas in cell O5 to O8 looking for exam results. I then want to use the Index formula to locate the cell that has the result in out of Cells O5 to O8 but for some reason it will only work if the result is in O5 and not O6 for example.
    =IFERROR(INDEX(O5:O8,MATCH("*",O5:O8,-1)),"") this is my formula

    I have added the IfError so if no result is there no error is shown
    Last edited by Jamidd1; 02-07-2016 at 06:05 PM. Reason: Added formula

  2. #2
    Forum Expert
    Join Date
    05-05-2015
    Location
    UK
    MS-Off Ver
    Microsoft? Excel? for Microsoft 365 MSO (Version 2402 Build 16.0.17328.20068) 64-bit
    Posts
    28,005

    Re: Index formula showing N/A or Value when data is present

    Please post a sample Excel file. Click "Go Advanced" then "Manage Attachments" to upload file.

  3. #3
    Forum Contributor
    Join Date
    02-07-2016
    Location
    England
    MS-Off Ver
    2019
    Posts
    270

    Re: Index formula showing N/A or Value when data is present

    Will do one minute

  4. #4
    Forum Contributor
    Join Date
    02-07-2016
    Location
    England
    MS-Off Ver
    2019
    Posts
    270

    Re: Index formula showing N/A or Value when data is present

    Exam Tracker Excel Help.xlsx Please See

    Student Details is the tab i am referring to
    Last edited by Jamidd1; 02-08-2016 at 04:52 AM.

  5. #5
    Forum Expert
    Join Date
    05-05-2015
    Location
    UK
    MS-Off Ver
    Microsoft? Excel? for Microsoft 365 MSO (Version 2402 Build 16.0.17328.20068) 64-bit
    Posts
    28,005

    Re: Index formula showing N/A or Value when data is present

    Try

    =IFERROR(INDEX(O5:O8,MATCH("?*",O5:O8,0)),"")

    MATCH will find the FIRST occurrence only

  6. #6
    Forum Contributor
    Join Date
    02-07-2016
    Location
    England
    MS-Off Ver
    2019
    Posts
    270

    Re: Index formula showing N/A or Value when data is present

    Thank you very much.
    That worked a charm. Exactly what i wanted.

    So what does the "?" do that the "*" didnt?
    Last edited by Jamidd1; 02-07-2016 at 06:03 PM.

  7. #7
    Forum Expert
    Join Date
    05-05-2015
    Location
    UK
    MS-Off Ver
    Microsoft? Excel? for Microsoft 365 MSO (Version 2402 Build 16.0.17328.20068) 64-bit
    Posts
    28,005

    Re: Index formula showing N/A or Value when data is present

    You didn't copy my changed formula

    =IFERROR(INDEX(O5:O8,MATCH("?*",O5:O8,0)),"")
    Last edited by JohnTopley; 02-08-2016 at 06:17 AM.

  8. #8
    Forum Contributor
    Join Date
    02-07-2016
    Location
    England
    MS-Off Ver
    2019
    Posts
    270

    Re: Index formula showing N/A or Value when data is present

    Sorry John, I did miss the * from the formula.

    Thank you very much.

+ 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. How do I make a chart showing time intervals that something is present?
    By smelltheflowers in forum Excel Charting & Pivots
    Replies: 5
    Last Post: 11-25-2014, 01:10 PM
  2. [SOLVED] Formula for weekly total, but not showing,until present month is entered.
    By paul*r in forum Excel Formulas & Functions
    Replies: 6
    Last Post: 06-07-2014, 09:48 AM
  3. Replies: 7
    Last Post: 01-23-2014, 11:30 PM
  4. [SOLVED] formula to tell me when someone is present on work, present late and early departure.
    By Shellybelly in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 12-03-2013, 01:38 AM
  5. Replies: 13
    Last Post: 09-06-2013, 07:52 PM
  6. [SOLVED] Auto Hiding rows based on range/data present or not present.
    By raze in forum Excel Programming / VBA / Macros
    Replies: 27
    Last Post: 02-10-2013, 11:27 AM
  7. [SOLVED] Formula returning a value when no data present
    By cmac7872 in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 10-12-2012, 01:37 PM

Tags for this Thread

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