Peform a vlookup using 3 conditions (non-numerical)...

[ladyday]

Hi,

I need assistance performing a vlook up in a table where I would like the formula to look at the data in Sheet 1, Columns A & B and if they match the information in Sheet 2, Columns A & B (same data) go back to Sheet 1 and look at the status of Column C and return a value of Y for pass or N for fail in Column C. I hope I said that correctly.

[TABLE="width: 266"]
<colgroup><col><col><col></colgroup><tbody>[TR]
[TD]Column A[/TD]
[TD]Column B[/TD]
[TD]Column C[/TD]
[/TR]
[TR]
[TD]Series[/TD]
[TD]Title[/TD]
[TD]Status[/TD]
[/TR]
[TR]
[TD]Grimm[/TD]
[TD]Bad Night[/TD]
[TD]Fail[/TD]
[/TR]
[TR]
[TD]Queen Sugar[/TD]
[TD]All Good[/TD]
[TD]Fail[/TD]
[/TR]
[TR]
[TD]Chicago Fire[/TD]
[TD]That Day[/TD]
[TD]Pass[/TD]
[/TR]
[TR]
[TD]This is Us[/TD]
[TD]Pilgrim Rick[/TD]
[TD]Pass[/TD]
[/TR]
</tbody>[/TABLE]

 

[Aladin Akyurek]

Aladin - thank you for looking into this. I was able to figure it and get it working. It ended up being:
{=INDEX('QC Status'!$N$2:$N$1365,MATCH('Episode List'!$D2&'Episode List'!$E2,'QC Status'!$A$2:$A$1365&'QC Status'!$B$2:$B$1365,0))}

Right. Thanks for coming back.