Dropdown formula to reference another sheet

Ken Hoffman

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.

Bassam Khalil

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.

Ken Hoffman

@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"

Ken Hoffman

Got it figured out. Using the VLOOKUP function I was able to cross reference.

BethL

@Ken Hoffman Can you share your formula please? This would be helpful for something similar I am working on. Thanks