title: Function Similar to importxml in Excel?
body: <p>I love using Google Docs function =importxml() but would love to know if there was anything like it in Excel 2010? I cant seem to find a way for the program to automatically pull data from a linked XML file.</p>
  
  <p>For example, I would love to be able to set up a column with the header "Item Name", then have  the next column append the user-entered item name in the previous column to this url</p>
  
  <pre><code>http://util.eveuniversity.org/xml/itemLookup.php?name=
  </code></pre>
  
  <p>and then parse the resulting XML file to return the type ID. This is accomplished in google docs using</p>
  
  <pre><code>=importxml(concatenate("http://util.eveuniversity.org/xml/itemLookup.php?name=",A3);"//itemLookup/typeID")
  </code></pre>
  
  <p>A3 is the column that has the item name, which in this case would be Tritanium, and imports the data form the resulting XML file</p>
  
  <pre><code>http://util.eveuniversity.org/xml/itemLookup.php?name=Tritanium
  </code></pre>
  
  <p>which returns the value 34.</p>
  
  <p>I have a list of about 20 item names that google docs automatically updates the item ID on every time I open the file. Is there any way for Excel 2010 to replicate this function?</p>
  
  <p>Thanks!</p>
  
  <p>Will</p>