Nov 15 2019 11:24 AM
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.
Nov 15 2019 05:05 PM
Apr 10 2020 12:19 PM
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.