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

CodePudding user response：

use:

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