I would upload the file I am working on but I am not able to.
I am trying to figure out a formula that can pull certain information to a specific tab based on the tab name (can repeat the tab name in a column). I thought about a vlookup but it is going to have multiple answers as there could be multiple document names. This is a tracking file for out of date company policies and I want to organize them based on the departments. For example, I want to pull in specific columns, the name of the document, the expiry date, and the person responsible.
I would have my raw data in the data dumb tap and then I would have 5 tabs (Administration, Board, Executive, HR, Finance) from my data dump I want to bring over all the documents to the administrative tab and the table will look like this;
What would be the formula I would use to get the policy name based on it being Administration? Same for the review date and the reviewer
I am trying to figure out a formula that can pull certain information to a specific tab based on the tab name (can repeat the tab name in a column). I thought about a vlookup but it is going to have multiple answers as there could be multiple document names. This is a tracking file for out of date company policies and I want to organize them based on the departments. For example, I want to pull in specific columns, the name of the document, the expiry date, and the person responsible.
I would have my raw data in the data dumb tap and then I would have 5 tabs (Administration, Board, Executive, HR, Finance) from my data dump I want to bring over all the documents to the administrative tab and the table will look like this;
What would be the formula I would use to get the policy name based on it being Administration? Same for the review date and the reviewer
Policy Name | Policy Review Date | Department | Reviewer |
Administration | |||
Administration | |||
Administration | |||
Administration |