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
Bookmarks