How to select result from table of data?

M. David

This is a weird one that I couldn't find any help on. I have two sheets. On the first one is a bunch of data and formulas, but the end result is a column with the number of miles each person has walked. The second sheet has a list of cities, along with their miles between each one and a cumulative number of miles for the full circuit. I would like to enter a formula into sheet one (column "Passed Location") where it looks at sheet two (column "Cumulative Miles") and tells me what location they have already passed. I included a picture of the second sheet below. Thank you for any and all help on this.

Paul Newcome

Are you able to provide a screenshot of the first sheet as well?

M. David

Here you go. These are just simple Excel examples. There are over 30 people and around 45 locations, so trying to do a massive IF statement seemed like a flawed solution. Thanks for the help.

Jeffrey_WRK

Use INDEX-MATCH with the MATCH search type of "1":

=INDEX(Location:Location, MATCH([Total Equiv. Miles]@row, Cumulative:Cumulative, 1))

I put both sheets in one for simplicity. To the left of the black bar is Sheet 1 and Sheet 2 is on the right.