How to get Index/Match or Vlookup to return specific matching value

[nmerchant]

I'm trying to use the INDEX and MATCH (or Vlookup) function to return only a specified value ("Paper Check") if it exists. If it does not exist, I want the return value to be "No". Sample below:

[TABLE="class: grid, width: 500"]
<tbody>[TR]
[TD][/TD]
[TD]A[/TD]
[TD]B[/TD]
[TD]C[/TD]
[TD]D[/TD]
[TD]E[/TD]
[TD]F[/TD]
[TD]G[/TD]
[/TR]
[TR]
[TD]1[/TD]
[TD]Name[/TD]
[TD]Check Type[/TD]
[TD]Payment Method[/TD]
[TD][/TD]
[TD][/TD]
[TD]Name[/TD]
[TD]Paper Checks?[/TD]
[/TR]
[TR]
[TD]2[/TD]
[TD]John Smith[/TD]
[TD]All[/TD]
[TD]Remaining Balance[/TD]
[TD][/TD]
[TD][/TD]
[TD]John Smith[/TD]
[TD]No[/TD]
[/TR]
[TR]
[TD]3[/TD]
[TD]Bill Johnson[/TD]
[TD]Regular[/TD]
[TD]Paper Check[/TD]
[TD][/TD]
[TD][/TD]
[TD]Bill Johnson[/TD]
[TD]Paper Check[/TD]
[/TR]
[TR]
[TD]4[/TD]
[TD]Bill Johnson[/TD]
[TD]Bonus[/TD]
[TD]Remaining Balance[/TD]
[TD][/TD]
[TD][/TD]
[TD]Mike Jones[/TD]
[TD]Paper Check[/TD]
[/TR]
[TR]
[TD]5[/TD]
[TD]Mike Jones[/TD]
[TD]Regular[/TD]
[TD]Paper Check[/TD]
[TD][/TD]
[TD][/TD]
[TD]Susan Lee[/TD]
[TD]No[/TD]
[/TR]
[TR]
[TD]6[/TD]
[TD]Mike Jones[/TD]
[TD]Bonus[/TD]
[TD]Fixed Amount[/TD]
[TD][/TD]
[TD][/TD]
[TD]Joe Austin[/TD]
[TD]Paper Check[/TD]
[/TR]
[TR]
[TD]7[/TD]
[TD]Mike Jones[/TD]
[TD]Bonus[/TD]
[TD]Remaining Balance[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]8[/TD]
[TD]Susan Lee[/TD]
[TD]Regular[/TD]
[TD]Remaining Balance[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]9[/TD]
[TD]Susan Lee[/TD]
[TD]Bonus[/TD]
[TD]Fixed Amount[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]10[/TD]
[TD]Joe Austin[/TD]
[TD]All[/TD]
[TD]Paper Check[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]

Is there a function that can achieve this? Thanks

 

[AhoyNC]

Here's one way.

Excel Workbook
	A	B	C	D	E	F	G
1	Name	Check Type	Payment Method			Name	Paper Checks?
2	John Smith	All	Remaining Balance			John Smith	No
3	Bill Johnson	Regular	Paper Check			Bill Johnson	Paper Check
4	Bill Johnson	Bonus	Remaining Balance			Mike Jones	Paper Check
5	Mike Jones	Regular	Paper Check			Susan Lee	No
6	Mike Jones	Bonus	Fixed Amount			Joe Austin	Paper Check
7	Mike Jones	Bonus	Remaining Balance
8	Susan Lee	Regular	Remaining Balance
9	Susan Lee	Bonus	Fixed Amount
10	Joe Austin	All	Paper Check
Sheet

 

[nmerchant]

That did the trick. Thank you so much