Best way to set-up an index contains

Options

Hello Smartsheet,

I have a sheet with URLs from our website that I need to be able to flag by division. To do this I have set-up a master sheet with the division's name and base URLs. What I need now is a formula to grab the division names from the master sheet. My intent was to set it up as an INDEX(MATCH()) but I realize now that the match function needs the values to be identical (I think at least).

So, what is the best way to grab the division names from the master sheet? Because the links I have are not "companyurl.com/division/example" (which is what is on my master sheet as the root URL) they are "companyurl.com/division/example/page1", "companyurl.com/division/example/sample" etc.

Unfortunately, the division URL's don't even follow the same structures (some are companyurl.com/division/sample and others are companyurl.com/abc123) which has made some of my initial thoughts go right out the window.

(For anyone wondering, the list will be getting updated/added to as we find more pages that the divisions need to make corrections/updates to, hence why we need to be able to break them down by division rather than just let them all hangout in huge list our web authors would then have to parse through).

Tags:

Best Answer

Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!