title: Google Spreadsheet importXML function
body: <pre><code>&lt;xml&gt;
      &lt;category date="5/21/2012"&gt;
          &lt;item&gt;14&lt;/item&gt;
      &lt;/category&gt;
  &lt;/xml&gt;
  </code></pre>
  
  <p>In cell A1 I have the following function:</p>
  
  <pre><code>=ImportXML("http://www.site.com/file.xml", "//@date")
  </code></pre>
  
  <p>And it successfully loads all the attribute values of name "date".</p>
  
  <p>Now in B1 I want to load the "item" that has the date in A1. I know the following is wrong but an idea of where I am trying to go:</p>
  
  <pre><code>=ImportXML("http://www.site.com/file.xml", "//@date["&amp;A&amp;ROW()&amp;"]/item")
  </code></pre>
  
  <p>Thank you in advance.</p>