Results 1 to 6 of 6

Nested Index Match Error

Threaded View

cyclops755 Nested Index Match Error 11-12-2012, 10:15 PM
vlady Re: Nested Index Match Error 11-12-2012, 10:24 PM
cyclops755 Re: Nested Index Match Error 11-12-2012, 10:44 PM
vlady Re: Nested Index Match Error 11-12-2012, 11:05 PM
cyclops755 Re: Nested Index Match Error 11-12-2012, 11:24 PM
vlady Re: Nested Index Match Error 11-13-2012, 01:26 AM
  1. #1
    Registered User
    Join Date
    08-18-2011
    Location
    East Coast, US
    MS-Off Ver
    Excel 2010
    Posts
    6

    Nested Index Match Error

    I tried searching for existing answers to this, as I know I'm far from the first person to run into this type of problem I'm sure, but the threads I found didn't seem to answer it for me.

    I'm having what I'm sure is a simple problem getting a nested Index/Match lookup formula to work. I'm trying to have the formula look through the output of a data trial and find the first value that is greater than 1000, then return the corresponding time that value occurred. The formula I have currently returns #N/A and is as follows:

    =INDEX(Data,MATCH(1000,INDEX(Data,,""Column No. of Position Data""),-1), ""Column No. of Time Data"")

    Where "Data" is the named range containing time and position data

    I've also attached the workbook for reference if needed. The formula in question is in Calculations!B15.

    Thanks in advance for your time
    Attached Files Attached Files

Thread Information

Users Browsing this Thread

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

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