Hi all,
Here's my problem:
I have a list of 1200 sub-accounts, and I want to group them into parent accounts Based on similar text with the sub-account name. For example, one vendor may have 30 different accounts that all have "Amazon" somewhere in the account name. Amazon India, Amazon China, Amazon.ca, etc. I'm envisioning somehow having a lookup table like the one below, and doing some sort of search function to see which parent category each account fits into. The second table's 2nd column would be the desired output based on subaccount name. Any idea how to do this?
Lookup table:
<tbody>
</tbody>
Data table:
<tbody>
</tbody>
Here's my problem:
I have a list of 1200 sub-accounts, and I want to group them into parent accounts Based on similar text with the sub-account name. For example, one vendor may have 30 different accounts that all have "Amazon" somewhere in the account name. Amazon India, Amazon China, Amazon.ca, etc. I'm envisioning somehow having a lookup table like the one below, and doing some sort of search function to see which parent category each account fits into. The second table's 2nd column would be the desired output based on subaccount name. Any idea how to do this?
Lookup table:
Search Text | ID | Parent Category |
Amazon | 1 | Amazon.com |
B&N | 2 | Barnes & Noble |
Pearson | 3 | Pearson |
<tbody>
</tbody>
Data table:
Subaccount | Parent Account (this column I want to fill in like below): |
Pearson-a | Pearson |
Pearson-b | Pearson |
Pearson-c | Pearson |
Pearson-d | Pearson |
Amazon China | Amazon.com |
Amazon India | Amazon.com |
<tbody>
</tbody>