Home

pull data based on dropdown list

%3CLINGO-SUB%20id%3D%22lingo-sub-1011906%22%20slang%3D%22en-US%22%3Epull%20data%20based%20on%20dropdown%20list%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1011906%22%20slang%3D%22en-US%22%3E%3CP%3EHey%20guys%2C%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E1%20worksheet%2C%202%20different%20tabs.%20On%20tab%201%2C%20I%20have%20a%20drop%20down%20status%20list%20for%20different%20projects%20(along%20with%20other%20project%20information%20in%20the%20row).%20When%20a%20specific%20status%20from%20the%20drop%20down%20list%20is%20chosen%2C%20I%20want%20that%20project%20(row%20of%20data)%20to%20populate%20automatically%20in%20a%20row%20in%20tab%202.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20am%20struggling%20to%20populate%20only%20the%20list%20of%20a%20specific%20status%20in%20tab%202%2C%20and%20populate%20the%20rest%20of%20the%20line.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1011906%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EDrop%20down%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EINDEX%20MATCH%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3Evlookup%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1012809%22%20slang%3D%22en-US%22%3ERe%3A%20pull%20data%20based%20on%20dropdown%20list%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1012809%22%20slang%3D%22en-US%22%3EYour%20sample%20Excel%20file%20will%20certainly%20reduce%20the%20struggle%20of%20those%20who%20might%20help%20you%20achieve%20your%20requirements.%3C%2FLINGO-BODY%3E
Highlighted
Occasional Visitor

Hey guys,

 

1 worksheet, 2 different tabs. On tab 1, I have a drop down status list for different projects (along with other project information in the row). When a specific status from the drop down list is chosen, I want that project (row of data) to populate automatically in a row in tab 2.

 

I am struggling to populate only the list of a specific status in tab 2, and populate the rest of the line.

 

1 Reply
Highlighted
Your sample Excel file will certainly reduce the struggle of those who might help you achieve your requirements.
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