pull data based on dropdown list

Copper Contributor

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

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.