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.

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>

 

[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