2

Look at the example I have below. 

A-.375-VG-M761   
A-.375-VG-O630  
A-.375-VG-O780   
A-.75-VG-602     
A-.75-VG-603     
A-.75-VG-604

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.

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

1 Answer 1

Reset to default
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%' ")
Improve this answer
2
  • Thank you, as a new comer to all of this there seems to be a ton to sort through for functions. This worked perfectly
    – Matthew Murray
    Dec 31, 2019 at 0:45
  • My pleasure. Glad it worked out.
    – marikamitsos
    Dec 31, 2019 at 1:15

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

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