Good afternoon all I am having trouble putting categories together.
I need a formula to do the following.
In cell A (Formula) I need it to tell me which user belongs to the category present in cell C (Category).
Cell B (user) is showing which users have which categories assigned to them.
If a category is not assigned to a user, it should say Other.
Thank You all.
<tbody>
</tbody>
I need a formula to do the following.
In cell A (Formula) I need it to tell me which user belongs to the category present in cell C (Category).
Cell B (user) is showing which users have which categories assigned to them.
If a category is not assigned to a user, it should say Other.
Thank You all.
Formula | User | Category |
Lynne | Medicare Managed Care | |
Lynne | ElderPlan | |
Lynne | Gov't Insurance | |
Lori | Commercial | |
Lori | Medicare | |
Damien | Guar | |
Beverly | Medicaid Managed Care | |
Beverly | No-Fault | |
Beverly | Workers Comp | |
Beverly | Workers Comp/No-Fault | |
Annop Skaria | Medicaid | |
Annop Skaria | Metroplus |
<tbody>
</tbody>