Extracting value from another sheet based on nested conditions

[alikhalil]

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.

 

[AliGW]

Cross-posted here: Excelguru.ca

 

[alikhalil]

Cross-posted here: Excelguru.ca

The thread didn't show up there though.

Bump. Anyone interested in answering please?

 

[alikhalil]

Default Extracting value from another sheet based on nested conditions

Anyone please?

 

[Macropod]

The thread didn't show up there though.

I have no difficulty accessing the thread at Excel Guru (Default Extracting value from another sheet based on nested conditions) and see that you have an ongoing discussion there re cross-posting.
Please read Mr Excel's policy on Cross-Posting in rule #13: http://www.mrexcel.com/forum/board-announcements/99490-forum-rules.html

 

[AliGW]

Paul - the thread on ExcelGuru was in moderation at that point - it has now been approved and a link back here provided.

 

[alikhalil]

@Macropod It just got approved.

Also, I just attached the workbook in that thread, if anyone is able to help through that please do so.