Formula Help

%3CLINGO-SUB%20id%3D%22lingo-sub-2680231%22%20slang%3D%22en-US%22%3EFormula%20Help%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2680231%22%20slang%3D%22en-US%22%3E%3CP%3ECan%20someone%20suggest%20a%20formula%20for%20the%20following%3F%26nbsp%3B%20%26nbsp%3BI%20have%20a%20worksheet%20where%20I%20need%20to%20have%20a%20drop%20down%20list%20of%20properties%2C%20based%20on%20what%20is%20chosen%20for%20the%20property%20in%20the%20next%20column%20I%20need%20a%20drop%20down%20list%20that%20chooses%20only%20the%20buildings%20associated%20with%20that%20property.%26nbsp%3B%20%26nbsp%3BIn%20the%20next%20column%20I%20would%20yet%20again%20need%20a%20drop%20down%20list%20of%20the%20units%20associated%20with%20that%20building%20at%20that%20property.%26nbsp%3B%20%26nbsp%3BCan%20anyone%20suggest%20anything%3F%26nbsp%3B%20I%20am%20using%20numbers%20as%20well%20as%20text.%26nbsp%3B%20%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2680231%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3ECommunity%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2680369%22%20slang%3D%22en-US%22%3ERe%3A%20Formula%20Help%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2680369%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F1136470%22%20target%3D%22_blank%22%3E%40accountinginnfinn%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EHello!%20You've%20posted%20your%20question%20in%20the%20%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Ftech-community-discussion%2Fbd-p%2FCommunityQuestions%22%20target%3D%22_blank%22%3ETech%26nbsp%3BCommunity%20Discussion%20space%3C%2FA%3E%2C%20which%20is%20intended%20for%20discussion%20around%20the%20Tech%20Community%20website%20itself%2C%20not%20product%20questions.%20I'm%20moving%20your%20question%20to%20the%20%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2FExcel%2Fbd-p%2FExcelGeneral%22%20target%3D%22_blank%22%3EExcel%20space%3C%2FA%3E%20-%20please%20post%20Excel%20questions%20here%20in%20the%20future.%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E
New Contributor

Can someone suggest a formula for the following?   I have a worksheet where I need to have a drop down list of properties, based on what is chosen for the property in the next column I need a drop down list that chooses only the buildings associated with that property.   In the next column I would yet again need a drop down list of the units associated with that building at that property.   Can anyone suggest anything?  I am using numbers as well as text.   

3 Replies

@accountinginnfinn 

Hello! You've posted your question in the Tech Community Discussion space, which is intended for discussion around the Tech Community website itself, not product questions. I'm moving your question to the Excel space - please post Excel questions here in the future. 

@accountinginnfinn 

You may google for "excel dependent drop-down list" for the instruction. First appeared in my search

How to make dependent dropdown lists in Excel | Exceljet

Creating a Dependent Drop Down List in Excel [Step-by-Step Tutorial] (trumpexcel.com)

@Sergei Baklan Got it, thank you!