Concatenate from dynamically updated sheet?

Vote count:

0

I have two sheets in my Excel 2010 book. Sheet "web" is updated by getting a web page with lots of tables with information. I only want to get three specific values in "web" sheet to my "main" sheet. As the row, where the information is, changes everytime (columns stay the same) i need to find the right values each time i open the book.

I can do this to get the correct cell for the first value i want:

=CONCATENATE("D";MATCH("VertCoin";'vert info'!C:C;0))

I then have to substitute the . to a , but how do i do that correctly considering the concatenation above? I can do something like this but as the row changes it will eventually give error:

=SUBSTITUTE('vert info'!D62; "."; ",")

asked 37 secs ago

user3310428

1