title: Use database connection in excel formula - no VBA
body: <p>Some years ago, I used an excel file where I could retrive DB values with an in-cell formula, but I can't replicate this function.</p>
  
  <p>My idea is to have a database connection (<code>access or sql</code>) with a connection to excel (<code>named "db1"</code>), in this there is a table ("<code>table1</code>") with some data about product and price (which are two colums).</p>
  
  <p>My formula should be something like this:</p>
  
  <pre><code>=get_from_db(db1;"table1";"product"="car";"value")
  </code></pre>
  
  <p>Output should be the price of the product car.</p>
  
  <p>Is it possible?</p>
  
  <p>Thanks for your help</p>
  
  <p>Simone</p>