ImportHTML Formula Help

**oyz79** · 02-25-2013, 01:18 AM

Hi,

I am familiar with the ImportHTML function, but I want to insert the text in a cell into the actual html. Is this possible?

For example, if I have the text "ABC" in cell A1, and the text "ABC" also exists within a url, and I periodically update the contents of cell A1, is it possible to inject the contents of A1 it into the following formula rather than having to manually type "ABC" into the link when I update cell A1:

=ImportHTML("http://finance.yahoo.com/q/hp?s=ABC&a=05&b=15&c=2012&d=01&e=6&f=2099&g=d","table",15)

**:) Sixthsense :)** · 02-25-2013, 01:56 AM

Is the placement of ABC in url is constant or variable? if so what is the mid area?

**oyz79** · 02-25-2013, 02:15 AM

Originally Posted by :) Sixthsense :)

Is the placement of ABC in url is constant or variable? if so what is the mid area?

It can vary and still be a valid url, but it is always in the same place in the url. For example, you can substitute xyz for abc and the url will still be valid.

**:) Sixthsense :)** · 02-25-2013, 02:18 AM

Not able to follow

can you please provide at least 2 or 3 example data and the expected outcome for better understanding

**oyz79** · 02-25-2013, 10:08 AM

Cell A1 contains the text 'ABC'. I want to change the contents of cell A1 on occasion. When I change the text in cell A1 to 'XYZ' I want it to automatically update the link used in the ImportHTML function to reflect the new text in cell A1.

For example, instead of =ImportHTML("http://finance.yahoo.com/q/hp?s=ABC&a=05&b=15&c=2012","table",15) I would like the url to read whatever is in cell A1 =ImportHTML("http://finance.yahoo.com/q/hp?s=A1&a=05&b=15&c=2012","table",15).

Thus, if I change the contents of cell A1 to XYZ the url will also update to http://finance.yahoo.com/q/hp?s=XYZ&a=05&b=15&c=2012