I have a worksheet with 2 tabs - Customers, Data. All tabs have a list of customers. The list on Data is a subset of all Customers. I need to pull available address information for Customers from Data.

I need the Address1-3 columns in Data to be joined using <br> and placed in the Address column in Customers. The situation seems

CodePudding user response：

Try this:

=ARRAYFORMULA(JOIN("<br>",QUERY({Data!A1:H6},"SELECT Col2,Col3,Col4 WHERE Col1 = '"&A2&"'",0)))

Edit: Harun24hr has the better answer, this will not autofill down.