How to put into Categories?

[bksparkz]

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.
[TABLE="width: 357"]
<tbody>[TR]
[TD="width: 158, bgcolor: transparent"]Formula
[/TD]
[TD="class: xl65, width: 158, bgcolor: transparent"]User
[/TD]
[TD="class: xl65, width: 159, bgcolor: transparent"]Category
[/TD]
[/TR]
[TR]
[TD="class: xl67, bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"]Lynne
[/TD]
[TD="class: xl66, bgcolor: transparent"]Medicare Managed Care
[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"]Lynne
[/TD]
[TD="class: xl66, bgcolor: transparent"]ElderPlan
[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"]Lynne
[/TD]
[TD="class: xl66, bgcolor: transparent"]Gov't Insurance
[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"]Lori
[/TD]
[TD="class: xl66, bgcolor: transparent"]Commercial
[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"]Lori
[/TD]
[TD="class: xl66, bgcolor: transparent"]Medicare
[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"]Damien
[/TD]
[TD="class: xl66, bgcolor: transparent"]Guar
[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"]Beverly
[/TD]
[TD="class: xl66, bgcolor: transparent"]Medicaid Managed Care
[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"]Beverly
[/TD]
[TD="class: xl66, bgcolor: transparent"]No-Fault
[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"]Beverly
[/TD]
[TD="class: xl66, bgcolor: transparent"]Workers Comp
[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"]Beverly
[/TD]
[TD="class: xl66, bgcolor: transparent"]Workers Comp/No-Fault
[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"]Annop Skaria
[/TD]
[TD="class: xl66, bgcolor: transparent"]Medicaid
[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"]Annop Skaria
[/TD]
[TD="class: xl66, bgcolor: transparent"]Metroplus
[/TD]
[/TR]
</tbody>[/TABLE]

 

[Jeffrey Mahoney]

This formula finds the first match in Column C. It looks like you have duplicates.

In Cell A2
=IF(MATCH(C2,$C$2:$C$13,0)>0,INDEX($B$2:$B$13,MATCH(C2,$C$2:$C$13,0)),"Other")

 

[bksparkz]

The above is just an example of which name is responsible for their category. If column B is not there, how can I write out this formula.
Another example is that Name of "Beverly" would show in column A if Column C shows "No-Fault", "Workers Comp", or Workers Comp/No-Fault"
Thank You

 

[Jeffrey Mahoney]

You should keep a master Table of categories and owners.

I'll think again on the formula, but it seems that a User Defined Function is in order. The issue is that you have duplicates in the set. You want it find a User that owns the category, but not the User on the current row.

Jeff