Hello,
I've created a Project Sheet that contains tasks from 3 different departments. Each department has it's own master sheet. Each master can be as many as 2500 rows and they all have identical column configuration.
I'm trying to retrieve info for the tasks in my project from these department sheets. A task may be in one, but only one of the department sheets - A or B or C. In the logic below, I am looking for the Task Status which is in column 4 in each of the department master sheets.
I've listed them in order of likelihood of the task being in a specific sheet. (90% of my project's tasks will be in department A)
The following is my logic:
1) Check for Task ID in Dept A Tasks
o If found, use it =VLOOKUP([Task ID]@row, {Dept A Tasks Range 1}, 4, 0)
o If not found:
2) Check for Task ID in Dept B Tasks
o If found, use it =VLOOKUP([Task ID]@row, {Dept B Tasks Range 1}, 4, 0)
o If not found:
3) Check for Task ID in Dept C Tasks
o If found, use it =VLOOKUP([Task ID]@row, {Dept C Tasks Range 1}, 4, 0)
I'm not sure how to construct this and whether I should be using "=IF" or "=IFERROR" or even "=INDEX/MATCH".
Any help would be appreciated. Thanks, Kevin
