CODEWITHSUNDEEP
google-sheetsfilterformulatextjoin
Fledgling Sysadmin
Fledgling Sysadmin

Reputation: 43

Google Sheets: Textjoin from another sheet not working

Working with the Base and Data tabs from this sheet: https://docs.google.com/spreadsheets/d/1OsSWQ_48VrcTU3pXGeJ_1syluKPVeVRune39UA9I3x4/edit?usp=sharing

Expected result is textjoin of all colors matching SKU separated by comma in column C on Base tab. Expected result shows in Column D, done manually.

All formulas i've tried either put everything in one cell (C2), gives an N/A error(C4), just pulls the first result (C5) or it is just completely blank.

Please help? If you cannot, then thank you for reading anyway.

Upvotes: 0

Views: 394

Answers (1)

Otávio Teixeira
Otávio Teixeira

Reputation: 21

I did it on a new Sheet on the Spreadsheet that i took the liberty to create (hope it's ok)

For getting the colors I used QUERY: so it came out as QUERY(Data!B:G,"select G where B = '"&A2&"'". After that I just fed that to your JOINTEXT formula

Upvotes: 1

Related Questions