Return multiple strings?

[blokeyhighlander]

I'm smacking my head against the wall because it seems like this should be easy

How do I return string values from multiple row lookups?

I have two tables:
1. Customers (one)
2. Contacts (many)

Contacts contains email addresses that I want to put in a calculated column on the Customers table. The Contacts table has multiple rows per customer ID (multiple email addresses per contact), so =related() doesn't work. Contacts does not have a complete listing of Customer IDs, and Customers table does have some email addresses (unique rows) that aren't in the Contacts table. There will be a filter on which email addresses to use based on criteria.

Is it possible to do this?

If I can't figure it out I may just need to write a query to join the customer data into the contacts table and I should be able to make that work.

 

[theBardd]

I must be missing something, but I cannot see why you would do this. If you join the tables in Power Pivot and then the client will display all of the email address associated with each customer. Pulling the multiples into the datamodel doesn't make sense to me.

 

[blokeyhighlander]

I must be missing something, but I cannot see why you would do this. If you join the tables in Power Pivot and then the client will display all of the email address associated with each customer. Pulling the multiples into the datamodel doesn't make sense to me.

You're right. I'm inexperienced in doing joins so I was trying to make it fit into something I already know, but a join makes a lot more sense.

 

[scottsen]

What you are looking for is CONCATENATEX. Unfortunately, that doesn't exist in any released products...

I can imagine pulling it off for a hard coded # of email addresses (say, 3 or whatever), ... with some pain.