ladyday
New Member
- Joined
- Dec 1, 2016
- Messages
- 15
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.
<colgroup><col><col><col></colgroup><tbody>
</tbody>
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>