• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User


  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Extract location of staff from one sheet to another using a formula.


New Member
Morning All,

I have a list of my staff's current locations and I want to extract a specific location based on user input from a dropdown list and add it to a new list.

Sheet 1 contains the location of all staff, while Sheet 2 should display only the staff based on the selected location. I have tried various methods, but have been unsuccessful.


  • location.xlsx
    11.4 KB · Views: 5
Thank you for your assistance. Both options are working great and I appreciate the additional features. Do you know where I can learn more about the formulas you used?