Google Sheets QUERY is returning with a no column found errors

Question

I have two sheets.

The master has a ton of data and columns A:EY with about 600 rows

R col is the name of the person CE col is the value of their deposit (formatted in dollars)

I need to import all names and deposits with a value in CE cell to another sheet

Here is the logic to the QUERY:

IF CE is not null, RETURN R (name) AND CE (deposit)

Here is my query:

=QUERY(Importrange("form_url","June 3-7 (Robert Martin)!A1:EY800"), "SELECT S,CE WHERE CE is not null")

The error is: Unable to parse query string for Function QUERY parameter 2: NO_COLUMN: S

When I change the QUERY to: =QUERY(Importrange("form_url","June 3-7 (Robert Martin)!A1:EY800"), "SELECT *")

it returns ALL the data from the MASTER.. what am I doing wrong??

** I cannot share the form data unfortunately.

Answer 1

Try

=QUERY(Importrange("form_url","June 3-7 (Robert Martin)!A1:EY800"), "SELECT Col19,Col83 WHERE Col83 is not null")

You can't use the column letter references because it's imported data.