CODEWITHSUNDEEP
google-sheetsfiltergoogle-sheets-formulamatchgoogle-query-language
user3227675
user3227675

Reputation: 43

SQL exact match in query for Google Sheets

Sure there is a simple way to solve this i'm just to rusty to remember it.

Heres my formula:

=QUERY('Test Sheet'!$3:$728, "select K where C contains '"SD"'")

Now in my test sheet there K has value "SD" and also "ASD" i want it to get the "SD" one only and not the ASD as well.

What do i put around the SD to specify that?

Thank you

Upvotes: 1

Views: 1829

Answers (1)

player0
player0

Reputation: 1

use:

=QUERY('Test Sheet'!3:728, "select K where C = 'SD'")

Upvotes: 1

Related Questions