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.