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%3CLINGO-SUB%20id%3D%22lingo-sub-1298859%22%20slang%3D%22en-US%22%3ERe%3A%20pull%20data%20based%20on%20dropdown%20list%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1298859%22%20slang%3D%22en-US%22%3E%3CP%3EHi%20you%20need%20a%20common%20data%20field%20in%20both%20tables%20(e.g.%20project%20number).%3C%2FP%3E%3CP%3EThen%20you%20can%20use%20the%20VLOOKUP%20function.%3C%2FP%3E%3CP%3EVLOOKUP(lookup_value%3Btable_array%3Bcol_index_num%3B%5Brange_lookup%5D%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3Elookup_value%3A%20e.g.%20cell%20with%20project%20number%3C%2FP%3E%3CP%3Etable_array%3A%20mark%20all%20data%20cells%20in%20the%20table%20you%20want%20to%20get%20the%20status%20from%3C%2FP%3E%3CP%3Ecol_index_num%3A%20number%20of%20column%20in%20which%20your%20status%20is%3C%2FP%3E%3CP%3Erange_lookup%3A%20FALSE%20(means%20%22exact%20match)%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EHope%20it%20helps.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%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.

 

2 Replies
Highlighted
Your sample Excel file will certainly reduce the struggle of those who might help you achieve your requirements.
Highlighted

Hi you need a common data field in both tables (e.g. project number).

Then you can use the VLOOKUP function.

VLOOKUP(lookup_value;table_array;col_index_num;[range_lookup]

 

lookup_value: e.g. cell with project number

table_array: mark all data cells in the table you want to get the status from

col_index_num: number of column in which your status is

range_lookup: FALSE (means "exact match)

 

Hope it helps.