One VLOOKUP cell gives me a column list of returns

SRenner ✭✭✭
edited 12/09/19 in Formulas and Functions

I am looking to have a drop down cell called "run name" that when changed will populate all the stores on that run. 

I was using VLOOKUP from a master store/run sheet to do this but could only figure out how to get one store to populate rather than the entire list of stores. 

Any help with this would be appreciated. 







smartsheet question for community.JPG



Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!