Look at the example I have below.


In one column I have two "SKUs": A-.375-VG and A-.75-VG.
I want to use this data to separate these SKUs onto two specific tabs of the same sheet.
How do I search through a column and return a cell if it contains a certain string of text?

I've tried REGEXMATCH and FIND but neither of those seem to do the trick.

  • Welcome. Please remember that as per site guidelines when an answer addresses your question, you should accept it so others can benefit as well. Commented Dec 30, 2019 at 23:12

1 Answer 1


(Assuming your data is in column Z and cells 10-17).

Use this formula for A-.375-VG in one tab:

=QUERY(Z10:Z17,"SELECT Z where Z like 'A-.375-VG%' ")

and for A-.75-VG in the other

=QUERY(Z10:Z17,"SELECT Z where Z like 'A-.75-VG%' ")
  • Thank you, as a new comer to all of this there seems to be a ton to sort through for functions. This worked perfectly Commented Dec 31, 2019 at 0:45
  • My pleasure. Glad it worked out. Commented Dec 31, 2019 at 1:15

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Not the answer you're looking for? Browse other questions tagged or ask your own question.