So here's the case. I have two sheets. The DA SR EDW sheet lists all SRs and along with them the different tasks that were opened by different task owners (thus duplicate SRs). The second sheet DA SR Consolidated I have just the SR and the call out employee (equivalent to the task owner name in the DA SR EDW sheet). In very simple terms, I'd like to look up the SR AND the task owner name and if they together match with what's in the second sheet, I'd like the three columns to be filled: Task Creation Date, Task Start Date, Task Closed date, in the DA SR Consolidated if the task is available in DA SR EDW.
Here's sheet 1 : DA SR EDW
And Sheet 2 DA SR Consolidated
Please help else i have to manually look up every single SR and i have about 500 piled up.
When i wrote nested conditions in the title I meant that first search the SR if it matches then within that SR look for the task owner name.
Here's sheet 1 : DA SR EDW
And Sheet 2 DA SR Consolidated
Please help else i have to manually look up every single SR and i have about 500 piled up.
When i wrote nested conditions in the title I meant that first search the SR if it matches then within that SR look for the task owner name.