Google-sheets – Query + importrange not providing the answer i need

google sheetsgoogle-sheets-queryimportrange

I am attempting to get some information from a Google sheet

Basically if my website Id was to be lets say 14, I'd want to get the name in the row next to it;

I am using the function below;

=QUERY(IMPORTRANGE("https://docs.google.com/spreadsheets/d/1er6drwogbR3-MAAYrtz96V1i_Cs0jTngcGYUeZ10rmA/edit#gid=1418684261", "A:Z"), "SELECT Col4 where Col5='14'")

My expected output would be 'Chad G' But I am getting 'Name' instead…

Best Answer

The problem is that Col5 has numbers but you are comparing it to a text value. Instead of Col5='14' use Col5=14

=QUERY(IMPORTRANGE("https://docs.google.com/spreadsheets/d/1er6drwogbR3-MAAYrtz96V1i_Cs0jTngcGYUeZ10rmA/edit#gid=1418684261", "A:Z"), "SELECT Col4 where Col5=14")

Related Solutions

Google Sheets – How to Query Data Using ImportHTML Function

I got it to work with this:

=QUERY(ImportHTML( "http://eciresults.nic.in/StatewiseU05.htm" , "table" , 9 ), "SELECT * where Col2>0",0)

Google Sheets Query – Combine Multiple Data Ranges into One Column

The "problem" is that the formula is using open references so there are a lot of blank cells from Table 1 above the Foo value.

One way to avoid having a lot of blank cells is to filter them out:

={QUERY(A3:B,"select A where A is not null AND B is null");QUERY(D3:F,"select D where(E='Yes' AND F is null)")}

Best Answer

Related Solutions

Google Sheets – How to Query Data Using ImportHTML Function

Google Sheets Query – Combine Multiple Data Ranges into One Column

Related Topic