title: Multiple indexes in XPath in Google Sheets importxml
body: <p>I'm using some data from Bloomberg into a Google spreadsheet, two of the lines read as:</p>
  
  <pre><code>=importxml("https://www.bloomberg.com/quote/ELIPCAM:BZ";"(//span)[28]")
  =importxml("https://www.bloomberg.com/quote/ELIPCAM:BZ";"(//span)[31]")
  </code></pre>
  
  <p>However, there is a large number of <code>importxml</code> and <code>importhtml</code> over all, and many of them querying the same web page. As a result, too many cells are in eternal "Loading..." state. Google even presents the message:</p>
  
  <blockquote>
    <p>"Loading data may take a while because of the large number of requests. Try to reduce the amount of IMPORTHTML, IMPORTDATA, IMPORTFEED or IMPORTXML functions across spreadsheets you've created."</p>
  </blockquote>
  
  <p>So, is there any way to merge requests as above? For sure I could open a new tab and import everything (i.e. use only <code>"(//span)"</code> for the query), but other than being messy, I'm afraid I'd still be querying more than I need. ideally, there should be some query for multiple numbered nodes, something like <code>"(//span)[28,31]"</code>, but this obviously returns an error.</p>