Excel 2016 XPath predicates

Hi,

 

I am trying to parse an XML document using the FILTERXML function. Unfortunately, I cannot get the XPath predicates to work correctly. Here is the https://www.lb.lt/webservices/FxRates/FxRates.asmx/getFxRates?tp=EU&dt=2018-01-01.

 

FILTERXML seems to be able to handle simple queries such as "//CcyAmt[2]/Amt" however more complex queries that involve searching for nodes keep on failing. One such example is "//CcyAmt[Ccy/text()='PLN']/Amt".

 

I have checked the second query with several XPath editors and they all return the correct result.

 

Thank you.