I feel like this should be a relatively simple issue but everything I write is clearly incorrect or leaves me needing to do work manually every time new data is made.

Basically I have a series of sheets that I want to import/filter all rows where Column C/3 matches a certain name.

Master sheet = WO#32456
Want to pull all rows from a large reference log of all my data where Column C/3 = WO#32456

Any help is appreciated!


Try a filter() formula like this:

  'Large reference log of all my data'!A2:F, 
  'Large reference log of all my data'!C2:C = "WO#32456" 

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.