CODEWITHSUNDEEP
google-sheetsgoogle-sheets-formula
Abhishek
Abhishek

Reputation: 3

Is it possible to include a formula within IMPORTHTML?

I have this Google sheet where 2 columns are present. Based on a drop down (of list of first column), I have used a vloopup to find corresponding values in second column. Straightforward.

However, when i reference the column containing vlookup formula in an IMPORTHTML statement, it doesn't give me results.

Any clues on how to fix this?

IMPORTHTML("https://www.moneycontrol.com/india/fnoquote/""&AB5""/""&AC5""/""&A1""","table",6)

Here AB5 is the drop down cell and AC5 is the cell containing vlookup. I realize AC5 is the issue as there is no error if I input the value manually.

Screenshot of my Google sheet

Upvotes: 0

Views: 54

Answers (1)

doubleunary
doubleunary

Reputation: 19220

Chances are that no quotes are required in the URL. Try this:

=importhtml("https://www.moneycontrol.com/india/fnoquote/" & AB5 & "/" & AC5 & "/" & A1, "table", 6)

Upvotes: 1

Related Questions