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.

  • 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 '19 at 23:12
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 – Matthew Murray Dec 31 '19 at 0:45
  • My pleasure. Glad it worked out. – marikamitsos Dec 31 '19 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.