title: Google Sheet Reverse VLOOKUP and Concatenate with Reference
body: <p>I need help to solve this problem in my google sheets.</p>
  <p><a href="https://i.stack.imgur.com/m5Ih4.png" rel="nofollow noreferrer">Problem</a></p>
  <p>After I search, the closest solution is:</p>
  <blockquote>
  <p>=TEXTJOIN(CHAR(10),,FILTER(A4:A10,C4:C10=E3))</p>
  </blockquote>
  <p>But the solution is not there.</p>
  <p>Can you help me out to solve this?</p>
  <p><a href="https://docs.google.com/spreadsheets/d/1GBmcjyr-YS_uGeNDajHGfnnnBrJS5uBUTfca531OC_o/edit?usp=sharing" rel="nofollow noreferrer">This is link to the sheets</a>
  Thank you in advance,</p>