I've been working on a google sheet that uses IMPORTXML to extract multiple data from different URLs in column N of same sheet. most of the data are imported correctly in the required cells but some cells are returning #NA [resource at url not found] and some are returning #NA [imported content is empty] I've tried all I can to no avail.
This is one of the formulas returning #NA [resource at url not found]. It is supposed to import kategoria from
- In this case, when the value of
kategoria
is not found, the empty value is returned.
Note:
In this sample formula, your provided URLs are used. So, when you use other URLs, this sample formula might not be able to be used. Please be careful about this.
From your question of
It is supposed to import kategoria from URL
, this sample formula retrieves the value ofkategoria
. So, when you want to retrieve other values, please post it as a new question.