INDEX/MATCH with Cross Sheet References

mwisk64

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!

Paul Newcome

You would use something along the lines of

=INDEX({Sheet B Column To Pull}, MATCH([Store Name]@row, {Sheet B Store Name}, 0))