title: Suggestions using Query function in Google spreadsheet
body: <p>Thank you for helping me out last time. I hope this time you can help me out to. See the following screenshots:</p>
  <pre><code>&lt;https://ibb.co/ZhP6Vhz&gt;
  &lt;https://ibb.co/bQZcV7v&gt;
  &lt;https://ibb.co/sgr5s6g&gt;
  &lt;https://ibb.co/QnypvJc&gt;
  </code></pre>
  <p>What I would like to achieve is the following. In cell &quot;J2&quot; I can select the name of the symbol I want. If this symbol is a Long-term investment or Short-term investment (data in Positions!F4:F30), then I want it to return table &quot;Stock&quot;. If it is a cryptocurrency, then I want it to return table &quot;Crypto&quot;.</p>
  <p>I know I can use the query function for this but my brain keeps giving me an error. I hope there is someone out there that can give me some advice!
  Thanks much in advance.</p>
  <p>If someone wants me to share it, here is the link:</p>
  <pre><code>https://docs.google.com/spreadsheets/d/1MqyAQd8t00qAcbusTFLYMG0eleRwuGq3mJCzI1pF0oI/edit?usp=sharing
  </code></pre>