Forum Discussion

Chandler Densley's avatar
Chandler Densley
Copper Contributor
Oct 20, 2018

How do I get this Google Sheets formula to work in Excel?

So I'm making a spreadsheet in Excel where I pull data from a video game website to get the most updated prices on in-game items. I've had a spreadsheet in Google Sheets that I've been using for a while now, and just recently decided I wanted to do it in Excel instead. However, the formula I used in Google Sheets doesn't work in Excel.

 

Here's the formula:


=Index(ImportHtml(Concatenate("http://services.runescape.***/m=itemdb_oldschool/results.ws?query=Grimy Torstol"), "table", 1),2,3)

 

The formula works exactly like I want it to in Google Sheets, but returns "#NAME?" in Excel.

 

Can anyone help me out here?

excel

1 Reply

Sort By
  • erol sinan zorlu's avatar
    erol sinan zorlu
    Iron Contributor
    Oct 24, 2018

    ImportHtml is not an Excel function, and thus returns an error. If you are trying to import data from a webpage, you can try using From Web funvctionality in DATA tab. Then change the data as you wish

Resources