Can you separate a cells text into different columns based on criteria?

[HockeyDiablo]

[TABLE="width: 312"]
<colgroup><col><col><col></colgroup><tbody>[TR]
[TD] A
1 TAGS_NAME[/TD]
[TD] B
TAGS[/TD]
[TD] C
NAME[/TD]
[/TR]
[TR]
[TD]2 Holly, Billing[/TD]
[TD]Billing[/TD]
[TD]Holly[/TD]
[/TR]
[TR]
[TD]3 Uncategorized[/TD]
[TD]Uncategorized[/TD]
[TD] [/TD]
[/TR]
[TR]
[TD]4 James[/TD]
[TD] [/TD]
[TD]James[/TD]
[/TR]
[TR]
[TD]5 Uncategorized[/TD]
[TD]Uncategorized[/TD]
[TD] [/TD]
[/TR]
[TR]
[TD]6 Existing Service, 7 Holly[/TD]
[TD]Existing Service[/TD]
[TD]Holly[/TD]
[/TR]
[TR]
[TD]8 Holly, Walkin[/TD]
[TD]Walkin[/TD]
[TD]Holly[/TD]
[/TR]
[TR]
[TD]9 WalkIn[/TD]
[TD]Walkin[/TD]
[TD] [/TD]
[/TR]
</tbody>[/TABLE]


Is there a way to place the correct texts from column A and place it in the appropriate column "b&c" based on if they are a TAG or NAME??

I cant seem to put my finger on it, seems easy but I cant quite gather the proper logic.

Thanks

 

[HockeyDiablo]

I placed the list of my Tags on V1 to V9

=IFERROR(LOOKUP(2^15,SEARCH($V$1:$V$9,A10),$V$1:$V$9),"")



I placed the list of my Names on U1 to U9

=IFERROR(LOOKUP(2^15,SEARCH($U$1:$U$9,A10),$U$1:$U$9),"")