INDEX/MATCH with Cross Sheet References
Hi there! I've looked through some articles and I can't seem to find a formula that works with my specific case. I am creating a log of requests received from specific stores in our company. My intent is the user would go into Sheet A and log the request then be able to type in the 'Store Name' and have 'Store State' and 'General Manager' auto-populate with data from Sheet B.
Sheet A has the following columns:
Sheet B has the following information with all of the columns complete with corresponding content:
Thank you so much!
Answers
-
You would use something along the lines of
=INDEX({Sheet B Column To Pull}, MATCH([Store Name]@row, {Sheet B Store Name}, 0))
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 66.1K Get Help
- 430 Global Discussions
- 149 Industry Talk
- 490 Announcements
- 5.2K Ideas & Feature Requests
- 85 Brandfolder
- 154 Just for fun
- 74 Community Job Board
- 499 Show & Tell
- 33 Member Spotlight
- 2 SmartStories
- 305 Events
- 36 Webinars
- 7.3K Forum Archives
Want to practice working with formulas directly in Smartsheet?
Check out the Formula Handbook template!
Check out the Formula Handbook template!