Web Applications Stack Exchange is a question and answer site for power users of web applications. Join them; it only takes a minute:

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

What I'm basically trying to do is use a URL previously made with the CONCATENATE function in an IMPORTHTML function.

When I try

importHTML (H1, "table", 0)

Where H1 is the cell with the concatenated URL, I get a #VALUE! error. Not even referencing H1 from a different sheet will work.

Any ideas about how to get past this? According to the usual syntax, the URL needs to be enclosed in double quotes. I'm trying to set things up so I only need to type in a few lines to automatically perform IMPORTHTML runs.

share|improve this question

Seems to work for me:

WA47779 example

Your formula is in K4. Maybe the first part of what you are concatenating has to be a valid address itself?

share|improve this answer

Your Answer


By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.