Search code examples
htmlgoogle-sheetsgoogle-sheets-macrosgoogle-sheets-formula

Index and import HTML not working in Google Sheets


I am trying to extract the certain value of a Single row of html table in 5th Row and third column from the below mentioned link

https://www.xe.com/currencytables/?from=USD&date=2020-02-07

the formula that I have used as mentioned below:

=index(IMPORTHTML("https://www.xe.com/currencytables/?from=USD&date=2020-02-07","table",0),5,3)

The formula doesnt extract the value in the cell instead it displays in the popup of google sheets.

I am looking to extract single value in 5th Row and third column . I tried using index and importxml but could not get any value.

Please help with the requiste formula to get the desired result .

Thanks


Solution

  • The formula seems to work fine for me.

    Example