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.

Column A	Column B	Column C
Series	Title	Status
Grimm	Bad Night	Fail
Queen Sugar	All Good	Fail
Chicago Fire	That Day	Pass
This is Us	Pilgrim Rick	Pass

<colgroup><col><col><col></colgroup><tbody>
</tbody>

 

[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.