Google sheets Query not returning values

Question

I have the following Query:

=QUERY('Fleury Braz Leme'!$A$31:$I$55;"select H, I, F, E where G = '"&I39&"'")

Some values from column E are being returned, but others are not. As you can see in the case below/above, on that linked sheet, there are corresponding values:

What can I do to correct it?

Have you tried the given solution? Did it work for you? If not we should try finding out why not. If yes, please remember that as per site guidelines when an answer addresses your question, accept it and even upvote it so others can benefit as well. — marikamitsos

player0 player0 · Accepted Answer · 2020-06-18T22:39:36

try:

=INDEX(QUERY(TO_TEXT('Fleury Braz Leme'!$A$31:$I$55);
 "select Col8, Col9, Col6, Col5 
  where Col7 = '"&I39&"'"))

Google sheets Query not returning values

1 Answers