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.



Tags:

Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!