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

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!