Here is my example sheet.
This is the formula that is not working:
=QUERY(IMPORTHTML("https://ct.thecmp.org/app/v1/index.php?do=match&task=getMatchResultsDetail&MatchId=12504&EventId=1&AwardId=1","TABLE",1),"SELECT Col1, Col2, Col4, Col5, Col6, Col7 where Col2 'Names!G:G'")
I would like to import the table, but only for the entries that match the names in column G of my Names Sheet.