Hello I need a formula for the following. I need to pull the name with multiple criteria. For example I need to know from MGM who by name has No-Action. Can anyone help please?
Sheet 1:
[TABLE="width: 500"]
<tbody>[TR]
[TD="align: center"]A[/TD]
[TD="align: center"]B[/TD]
[TD="align: center"]C[/TD]
[/TR]
[TR]
[TD="align: center"]
Name[/TD]
[TD="align: center"]
Org.[/TD]
[TD="align: center"]Action[/TD]
[/TR]
[TR]
[TD]Johnson[/TD]
[TD]MGM[/TD]
[TD]No-Action[/TD]
[/TR]
[TR]
[TD]Robinson[/TD]
[TD]CDF[/TD]
[TD]Active[/TD]
[/TR]
[TR]
[TD]Williams[/TD]
[TD]MGM[/TD]
[TD]No-Action[/TD]
[/TR]
[TR]
[TD]Tuck[/TD]
[TD]BPM[/TD]
[TD]Pending[/TD]
[/TR]
[TR]
[TD]Wright[/TD]
[TD]LOI[/TD]
[TD]Processing[/TD]
[/TR]
</tbody>[/TABLE]
Sheet 2: Output:
[TABLE="width: 500"]
<tbody>[TR]
[TD]
[/TR]
[TR]
[TD]Name[/TD]
[/TR]
[TR]
[TD]Johnson[/TD]
[/TR]
[TR]
[TD]Williams[/TD]
[/TR]
</tbody>[/TABLE]
Sheet 1:
[TABLE="width: 500"]
<tbody>[TR]
[TD="align: center"]A[/TD]
[TD="align: center"]B[/TD]
[TD="align: center"]C[/TD]
[/TR]
[TR]
[TD="align: center"]
Name[/TD]
[TD="align: center"]
Org.[/TD]
[TD="align: center"]Action[/TD]
[/TR]
[TR]
[TD]Johnson[/TD]
[TD]MGM[/TD]
[TD]No-Action[/TD]
[/TR]
[TR]
[TD]Robinson[/TD]
[TD]CDF[/TD]
[TD]Active[/TD]
[/TR]
[TR]
[TD]Williams[/TD]
[TD]MGM[/TD]
[TD]No-Action[/TD]
[/TR]
[TR]
[TD]Tuck[/TD]
[TD]BPM[/TD]
[TD]Pending[/TD]
[/TR]
[TR]
[TD]Wright[/TD]
[TD]LOI[/TD]
[TD]Processing[/TD]
[/TR]
</tbody>[/TABLE]
Sheet 2: Output:
[TABLE="width: 500"]
<tbody>[TR]
[TD]
A
[/TD][/TR]
[TR]
[TD]Name[/TD]
[/TR]
[TR]
[TD]Johnson[/TD]
[/TR]
[TR]
[TD]Williams[/TD]
[/TR]
</tbody>[/TABLE]