Google Sheets Query – Use Criteria Where Col1 Equals Cell Value

google-sheets-query

https://docs.google.com/spreadsheets/d/1kYkfBoDsJR-sBo5J52lJTXKa-EXoFYPgVPnrRGvOx5A/edit?usp=sharing

=query(Importrange("1kYkfBoDsJR-sBo5J52lJTXKa-EXoFYPgVPnrRGvOx5A","LastRevision!A5:Y"),"Select * where Col3 = '"&B28&"'",1)
What is wrong with '"&B28&"' instead of just typing the number.
Why its showing error..
'"&B28&"' contains a number which I want to match with the reference column. If I just type the number it works well, but referring to the cell that has the number doesn't work.

Best Answer

Ok. I got it. first I have to convert that into a text in another cell =TEXT('CASES LIST'!C6,"D") then use this cell as reference.. Thanks

Related Solutions

Google Sheets – Query Syntax Using Cell Reference

Please try syntax of this kind:

=QUERY(Responses!B1:I, "Select B where G contains '"&$B1&"'")

Google Sheets Query – Column Not Equal to Any Cell in Another Sheet

Query is great for comparison of fields withing the same record (row) but it does not easily do the kind of lookups you want. It is possible to manifacture a long query string where A <> 'this' and A <> 'that'... with a separate formula, but this is not an enjoyable exercise.

On the other hand, filter is pretty easy to use here:

=filter(F:F, C:C=14, isna(match(A:A, Sheet2!A:A, 0)))

says: find all entries in F where the C value is 14 and the value in A does not match anything in Sheet2 column A. The function match returns #N/A when the value is not found, and this is what isna looks for.

Then it's just the matter of taking max of those:

=max(filter(F:F, C:C=14, isna(match(A:A, Sheet2!A:A, 0))))

Best Answer

Related Solutions

Google Sheets – Query Syntax Using Cell Reference

Google Sheets Query – Column Not Equal to Any Cell in Another Sheet

Related Topic