title: How to use parameterized query in Excel using column as parameter?
body: <p>I am trying to develop a spreadsheet that can locate corresponding records in an external data source.  So, let's say I have Column A with a list of identity values.  I want to develop Column B, which perhaps shows a count of rows in the table with that value.  Something like:</p>
  
  <pre><code>A              B
  758348    "=SELECT COUNT(*) FROM MYTABLE WHERE IDVALUE=$A$1"
  173483    "=SELECT COUNT(*) FROM MYTABLE WHERE IDVALUE=$A$2"
  </code></pre>
  
  <p>... and so on.  So, I thought I would use a parameterized query (where IDVALUE=?), but that prompts me to input the parameter value, not use the value from the cell to the left.  Is there any way I can do this?</p>