Home

Drop Down List - Linking Corresponding Data in Separate Columns Based on Drop Down Selection

%3CLINGO-SUB%20id%3D%22lingo-sub-338731%22%20slang%3D%22en-US%22%3EDrop%20Down%20List%20-%20Linking%20Corresponding%20Data%20in%20Separate%20Columns%20Based%20on%20Drop%20Down%20Selection%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-338731%22%20slang%3D%22en-US%22%3E%3CP%3EHey%20there!%20I'm%20looking%20for%20a%20clear%20cut%20way%20to%20do%20something%20which%20seems%20like%20it%20should%20be%20simple.%20I%20have%20two%20columns%20that%20I%20want%20to%20correspond%20with%20one%20another.%20What%20I'm%20looking%20to%20do%20is%20when%20someone%20selects%20an%20option%20%22Status%22%20from%20the%20drop-down%20list%20in%20Column%20D%20the%20adjacent%20cell%20in%20column%20E%20populates%20with%20a%20corresponding%20percentage%20value.%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EEx.%20--%26gt%3B%20Cell%20'D6'%20%2F%20%22Sales%20Status%22%20Drop%20Down%20Selection%20%3D%20Verbal%20Commitment%20%3A%3A%3A%20Needing%20Cell%20'E6'%20to%20auto-populate%20once%20selected%20with%20the%20corresponding%20percentage%20%22100%25%22%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI've%20built%20a%20drop%20down%20list%20for%20each%20column%20in%20a%20data%20worksheet.%20Am%20I%20doing%20this%20correctly%3F%20I've%20attached%20a%20screenshot%20of%20the%20columns%20I%20need%20populated%20as%20well%20as%20my%20lists%20in%20case%20that%20helps.%20Thanks!%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-left%22%20style%3D%22width%3A%20342px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Fgxcuf89792.i.lithium.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F74925iA67B47DC879940C3%2Fimage-size%2Fmedium%3Fv%3D1.0%26amp%3Bpx%3D400%22%20alt%3D%22Columns.PNG%22%20title%3D%22Columns.PNG%22%20%2F%3E%3C%2FSPAN%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-left%22%20style%3D%22width%3A%20400px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Fgxcuf89792.i.lithium.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F74926iC33DA894CF72EE06%2Fimage-size%2Fmedium%3Fv%3D1.0%26amp%3Bpx%3D400%22%20alt%3D%22Data%20Table.PNG%22%20title%3D%22Data%20Table.PNG%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-338731%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3Edata%20validation%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EDrop-Down%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EFormulas%20and%20Functions%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3ELists%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-339429%22%20slang%3D%22en-US%22%3ERe%3A%20Drop%20Down%20List%20-%20Linking%20Corresponding%20Data%20in%20Separate%20Columns%20Based%20on%20Drop%20Down%20Selection%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-339429%22%20slang%3D%22en-US%22%3EJust%20thought%2C%20you%20may%20want%20to%20use%20it%20with%20a%20IF%20function%20in%20case%20there%20is%20nothing%20selected%20in%20the%20Sales%20Status%20column%2C%20i.e.%20%3DIF(D6%3D%22%22%2C%22%22%2CVLOOKUP(D6%2CStatusTable%2C2))%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-339423%22%20slang%3D%22en-US%22%3ERe%3A%20Drop%20Down%20List%20-%20Linking%20Corresponding%20Data%20in%20Separate%20Columns%20Based%20on%20Drop%20Down%20Selection%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-339423%22%20slang%3D%22en-US%22%3E%3CP%3EIf%20you%20make%20your%20info%20on%20the%20data%20worksheet%20a%20table%2C%20ie%20%22StatusTable%22%20covering%20both%20columns%20then%20in%20Confidence%20Level%20column%20use%20this%20formula%2C%20%26nbsp%3B%26nbsp%3B%3DVLOOKUP(D6%2CStatusTable%2C2).%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E
GangiOnSite
Occasional Visitor

Hey there! I'm looking for a clear cut way to do something which seems like it should be simple. I have two columns that I want to correspond with one another. What I'm looking to do is when someone selects an option "Status" from the drop-down list in Column D the adjacent cell in column E populates with a corresponding percentage value. 

 

Ex. --> Cell 'D6' / "Sales Status" Drop Down Selection = Verbal Commitment ::: Needing Cell 'E6' to auto-populate once selected with the corresponding percentage "100%"

 

I've built a drop down list for each column in a data worksheet. Am I doing this correctly? I've attached a screenshot of the columns I need populated as well as my lists in case that helps. Thanks!

 

Columns.PNGData Table.PNG

 

 

 

 

 

 

 

 

 

 

 

2 Replies

If you make your info on the data worksheet a table, ie "StatusTable" covering both columns then in Confidence Level column use this formula,   =VLOOKUP(D6,StatusTable,2). 

Just thought, you may want to use it with a IF function in case there is nothing selected in the Sales Status column, i.e. =IF(D6="","",VLOOKUP(D6,StatusTable,2))
Related Conversations
flashing a white screen while open new tab
cntvertex in Discussions on
13 Replies
Tabs and Dark Mode
cjc2112 in Discussions on
22 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