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>
</tbody>
Sheet 2: Output:
<tbody>
</tbody>
Sheet 1:
A | B | C |
Name | Org. | Action |
Johnson | MGM | No-Action |
Robinson | CDF | Active |
Williams | MGM | No-Action |
Tuck | BPM | Pending |
Wright | LOI | Processing |
<tbody>
</tbody>
Sheet 2: Output:
A |
Name |
Johnson |
Williams |
<tbody>
</tbody>