Home

Drop Down

%3CLINGO-SUB%20id%3D%22lingo-sub-897973%22%20slang%3D%22en-US%22%3EDrop%20Down%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-897973%22%20slang%3D%22en-US%22%3E%3CP%3EI%20have%20a%20drop%20down%20created%20on%20sheet%201%20and%20need%20the%20sheet%20to%20populate%20data%20from%20sheet%202%20based%20upon%20which%20drop%20down%20is%20selected%20from%20sheet%201.%20I%20know%20each%20data%20cell%20needs%20a%20formula%20to%20first%20reference%20the%20drop%20down%20cell%20to%20understand%20which%20site%20to%20look%20at%20and%20from%20there%20which%20data%20value%20to%20pull%20from%20sheet%202%2C%20but%20I'm%20unfamiliar%20with%20the%20string%20formula%20process.%20Thanks%20in%20advance.%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-897973%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EFormulas%20and%20Functions%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-898249%22%20slang%3D%22en-US%22%3ERe%3A%20Drop%20Down%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-898249%22%20slang%3D%22en-US%22%3E%3CP%3EHi%20%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F421614%22%20target%3D%22_blank%22%3E%40Spina188%3C%2FA%3E%26nbsp%3B%2C%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3ECould%20you%20share%20how%20you%20organize%20the%20Sheet%201%20and%20Sheet%202%3F%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3ERegards%3C%2FP%3E%3C%2FLINGO-BODY%3E
Highlighted
Occasional Visitor

I have a drop down created on sheet 1 and need the sheet to populate data from sheet 2 based upon which drop down is selected from sheet 1. I know each data cell needs a formula to first reference the drop down cell to understand which site to look at and from there which data value to pull from sheet 2, but I'm unfamiliar with the string formula process. Thanks in advance. 

1 Reply
Highlighted

Hi @Spina188 ,

 

Could you share how you organize the Sheet 1 and Sheet 2?

 

Regards