title: How to use query with spreadsheet and relative cell reference
body: <p>PROBLEM: I am trying to use queries in google spreadsheets with a relative cell reference.
  What I am trying to do: Filter a spreadsheet tab 'website!' for the content in a cell 'Dashboard Table!$B$1' and give the content of the whole row in the sheet 'website!'.</p>
  
  <p>Here is my original formular without queries: <code>=IF(isblank($B$1), ARRAYFORMULA(Website!A16:D1000), FILTER(Website!A16:D$1000, Website!$C16:$C$1000=$B$1))</code> that worked fine.</p>
  
  <p>What I am trying now: <code>=QUERY(Website!A16:D, "select A WHERE C="&amp;B1&amp;"", -1)</code> not working at all returning #value!.</p>
  
  <p>Sorry I am new to queries. Can anyone advice?</p>