Need to fill a file by linking values from a data dump to there respective pages in the workbook.
It was formally done by direct links (which was nuts and can't be done anymore anyway because the report has changed. Now I would like to use a vlookup but for each tab it has to fit 2 criteria it needs to belong to a certain department (1st criteria) and the category the number belongs to (2nd criteria)
Since the categories repeat on the report every time the department header changes I need excel to first find the section on the report that is the corresponding department and then within the department find the value for the category.
Eg.
Departments are Alpha, Bravo, Charlie, Delta, Echo
Catagories are Tulips, Daisies, Lilies, Roses
On the data dump Tulips Daises Lilies and Roses will repeat everytime the Dept changes. Dept is listed in A column on data dump sheet.
My sheet has the dept name in one cell "A3" and the catagories are listed in column B going down
Tulips
Daisies
Lilies
Roses
I need a formula that will look at cell A3 I am working on and if the value matches any value in column A on the pull sheet then find the category on the line in column b on fill sheet and give me the value that belongs from pull sheet in columns c-t depeding on which number I assign c would be 2 from category if a v lookup and d would be 3 and so on.
Or a better way if you have any suggestions. Thx
It was formally done by direct links (which was nuts and can't be done anymore anyway because the report has changed. Now I would like to use a vlookup but for each tab it has to fit 2 criteria it needs to belong to a certain department (1st criteria) and the category the number belongs to (2nd criteria)
Since the categories repeat on the report every time the department header changes I need excel to first find the section on the report that is the corresponding department and then within the department find the value for the category.
Eg.
Departments are Alpha, Bravo, Charlie, Delta, Echo
Catagories are Tulips, Daisies, Lilies, Roses
On the data dump Tulips Daises Lilies and Roses will repeat everytime the Dept changes. Dept is listed in A column on data dump sheet.
My sheet has the dept name in one cell "A3" and the catagories are listed in column B going down
Tulips
Daisies
Lilies
Roses
I need a formula that will look at cell A3 I am working on and if the value matches any value in column A on the pull sheet then find the category on the line in column b on fill sheet and give me the value that belongs from pull sheet in columns c-t depeding on which number I assign c would be 2 from category if a v lookup and d would be 3 and so on.
Or a better way if you have any suggestions. Thx
