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!
Help Article Resources
Check out the Formula Handbook template!