Take the 2-minute tour ×
Web Applications Stack Exchange is a question and answer site for power users of web applications. It's 100% free, no registration required.

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

1 Answer 1

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

 
discard

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.