Test Sheet for my use case: https://docs.google.com/spreadsheets/d/1_gcyygG8IhVc-4mXf8n09IFG5ZIYuK_UxWxPLQ5av-k/edit?usp=sharing

I've had some input from another user on the site helping me search through one tab of data in my sheet and pull results. Now I'm wondering if its possible to do that but also look through multiple tabs.

In the "Partial Answer" tab, it shows how it would work with a single tab ('Car Parts') but it broke when U transferred it over to this new sheet. Besides the point, I would like the "Search Tab" tab be able to look for a keyword in 'A2' and return results in 'B2:B' from all my tabs (Hoods, Bumpers, and Doors) as well as link to the row the data was pulled from in the query in B2:

=iferror(query('Car Parts'!A2:A,"select A where upper(A) contains '"&UPPER(A2)&"' ",0), "not found")

1 Answer 1


Instead of a single range

'Car Parts'!A2:A

use an array of ranges (break lines included for readability, but you could write this in a single line)



instead of A in the select statement use Col1

  • There should be a similar answer on this site including links to the help article about using arrays in Google Sheets, maybe later I will add the corresponding link. Jan 13, 2021 at 20:30
  • This doesn't work? What have I done wrong? =iferror(query({Hoods!C2:C; Bumpers!C2:C; Doors!C2:C},"select Col1 where upper(A) contains '"&UPPER(A2)&"' ",0), "not found")
    – Willmk
    Jan 13, 2021 at 20:53
  • You missed to change the A inside upper Jan 13, 2021 at 21:07

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.