Dropdown formula to reference another sheet
I am trying to create a formula to accomplish the following.
If 03 is selected from my dropdown, reference another sheet to find out who the manager is of store 03.
Answers
-
Hi @Ken Hoffman
Hope you are fine, you can do that by using Vlookup Or Index with Match functions, Please add a copy of your sheet or a screenshot (after removing or replacing any sensitive information). This will make it easier for me to provide the appropriate answer to your question.
bassam.khalil2009@gmail.com
☑️ Are you satisfied with my answer to your question? Please help the Community by marking it as an ( Accepted Answer), and I will be grateful for your "Vote Up" or "Insightful"
-
@Bassam.M Khalil I hope this helps. I am still rather new to this and don't know how to share a copy. The Sheet that I dispatch from has the Store Number as a dropdown. All the emails are made up on my "store list test"
-
Got it figured out. Using the VLOOKUP function I was able to cross reference.
-
@Ken Hoffman Can you share your formula please? This would be helpful for something similar I am working on. Thanks
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 64.6K Get Help
- 433 Global Discussions
- 136 Industry Talk
- 468 Announcements
- 4.9K Ideas & Feature Requests
- 143 Brandfolder
- 147 Just for fun
- 64 Community Job Board
- 466 Show & Tell
- 32 Member Spotlight
- 2 SmartStories
- 298 Events
- 36 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!