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:
<tbody>
A
B
C
Name
Org.
Action
Johnson
MGM
No-Action
Robinson
CDF
Active
Williams
MGM
No-Action...