How to select result from table of data?

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.



Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!