Forum Discussion
pull data based on dropdown list
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 do...
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.