0

I have a tab in Google sheets with vehicle data coming from a google form. I made another tab to filter these data using a data validation. The validations are Car 1, Car 2, Car 3, Truck 1, Truck 2, Truck 3. This works perfectly. I'd like to know if I can add "Car" to the list which would pull Car 1, Car 2 and Car 3 at the same time. Is it possible?

Improve this question

1 Answer 1

Reset to default
0

Use QUERY() function.

=QUERY(Sheet1!A:C,"where C contains '" & D1 &"'")

enter image description here

Improve this answer
Sign up to request clarification or add additional context in comments.

1 Comment

Simple, I was stuck in the validation so did not think about the "Filter" formula

Your Answer

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

Start asking to get answers

Find the answer to your question by asking.

Ask question

Explore related questions

See similar questions with these tags.