Saturday, May 21, 2011

yogi_Insert A Cell Value In An Import Function

Yogi Anand, D.Eng, P.E.                                         Google Spreadsheet                  
franzellin said:
I have a function where I import from yahoo finance the value of an option, the value is defined as:
I would like to modify TBT110618p00035000 in
&A1&A2&A3&000&A4&000 where
a1= cell with the content "TBT"
a2= cell with the content "110618"
a3= cell with the content "c"
a4= cell with the content "35"
I tried to simplify
cell B18=TBT110618p00035000
cell C18=index(ImportHtml("";"table";1);1;2)
but I have still no success
In reference to the first question I have incorporated the values of variable entries in cells A1,A2,A3, and A4 in the formula in cell B6
in cell B10 the formula in cell b2 is modified to incorporate the variable entry in cell A10