Account mapping across multiple fields

[tiverson]

I have a table of accounts for multiple companies and need to assign the description to my data by ARE.

Thanks!

Account listing by ARE 

Data

Output

[Luke_C · Accepted solution]

Hi @tiverson 

Here's how:

1. Transpose your lookup data so the acct types are rows instead of columns
2. Join the data by ARE and Acct number
3. Union the fall outs for AREs/Accounts that didn't join

[tiverson]

@Luke_C , awesome.  Thanks for the quick reply!