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
Highlighted
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). 

Highlighted
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
WVD On/Off based on activity
Adam Black in Windows Virtual Desktop on
0 Replies
What data does Microsoft collect?
Tim_Gent in Microsoft Teams on
1 Replies
SharePoint 2013 LIst Filters (by latest date)
dmphil in SharePoint on
0 Replies
SharePoint Lists - Expanded View Roadmap ID: 57302
Kotus-Tech in SharePoint on
12 Replies