Home > Software engineering >  Match lookup value with importHTML and combine tables in Soogle Sheet
Match lookup value with importHTML and combine tables in Soogle Sheet

Time:01-04

I have total 2 url links both of which match lookup value and want column of second table in first table.

I have first taken a table from the importhtml formula. And the cell that is green is the column lookup value. Which is as follows.

1st table enter image description here

And there is another table in which I want to match the lookup values from the first table and all the values from that table. Which I have tried. Within this google sheet and you can also try in this google sheet.\

=VLOOKUP(B3,IMPORTHTML("https://www.screener.in/screens/881791/rk-holding/?page=1", "table",1),12,0)

2nd table enter image description here

In column next to roce I want column of promoter holding. Which you have to take from this url link.

get result like

enter image description here

try this in google sheet. : enter image description here

  • Related