One VLOOKUP cell gives me a column list of returns

SRenner
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. 

 

Thanks

Scott

 

 

 

smartsheet question for community.JPG

«13

Comments

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!