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
Spina188
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

Hi @Spina188 ,

 

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

 

Regards

Related Conversations
Tabs and Dark Mode
cjc2112 in Discussions on
22 Replies
flashing a white screen while open new tab
cntvertex in Discussions on
13 Replies
Stable version of Edge insider browser
HotCakeX in Discussions on
35 Replies
How to Prevent Teams from Auto-Launch
chenrylee in Microsoft Teams on
28 Replies
PacketMon Components are not loading in WAC 1909
HotCakeX in Windows Admin Center on
2 Replies