Impress your boss by creating a search function from multiple tabs using Google sheets

CTRL find is fine when searching for one offs but if you’re searching for items constantly, creating a search function is the way to go. If all of the data is already in one list it’s super easy to set up.
Unfortunately, things aren’t always clean but using data from multiple sources is definitely still possible as you can see in this video.
There are a ton of use cases for this and it’s sure to impress your boss and colleagues.
Final Formula:
=filter(filter(VSTACK('Data 1'!A2:D,'Data 2'!A2:D),
VSTACK('Data 1'!A2:A,'Data 2'!A2:A)__""),
SEARCH(A3,filter(VSTACK('Data 1'!A2:A,'Data 2'!A2:A),
VSTACK('Data 1'!A2:A,'Data 2'!A2:A)__"")))
**Note: I am unable to input angle brackets in the description. Please replace __ in the above formula with the not equals to sign. The not equals to sign is less than sign to followed by a greater than sign.

[@JoshuaSmith-h8z]

Great Video... It's exactly what I'm trying to do. Pull Data from different Tabs based on inventory location. However, I couldn't get it to work. Any chance you can put the FORMULA in the Description? I believe I copied it out perfectly but it was still generating an error. on my end. Thanks in advance!

[@sheetsbyolan]

Just added the formula. I wasn't able to include a not equals to sign in the description due to youtube character descriptions. Make sure to read the note to know the work around. Let me know if you're still having trouble.

[@JoshuaSmith-h8z]

@@sheetsbyolan THAT WORKED LIKE A CHAMP! Only issue I had was the Formula didn't like any extra ROW spacing in the Sheet Tab. I had to remove all the extra rows that doesn't have data in them and it returned my desired results!!! Thank You So Much! Been ripping my hair out trying to figure this out. Not this formula but other ones too. Couldn't figure out how to add to the formula to allow for additional Sheet Tab's to be included in a SEARCH.

[@sheetsbyolan]

@@JoshuaSmith-h8z glad you got it to work! 🙌🏼

[@JoshuaSmith-h8z]

@@sheetsbyolan You got it to work, I just plagiarized your work! Thank You!

[@JoshuaSmith-h8z]

@@sheetsbyolan One more question, is there a way to add an IF(ISBLANK) statement to put in that formula so that when the search field is blank it won't pull the whole data set? Once again Thank You in advance!!! Appreciate it!

[@kellinquinnscheese]

this is exactly what i'm trying to do but still cant get it to work even with using the formula in the description, any ideas? i have something like 10 tabs to filter data from... it seems to pull only from the first tab and once i start to try and do the sexond part of the forumla i get a ref error

[@sheetsbyolan]

@@kellinquinnscheese check out my video on combining ranges I posted recently. It shows a way simpler than vstack that works better. I recommend using the curly brackets with the query formula to remove the blanks since you’re combining so many ranges. I recommend combining all of the ranges into one list before trying to add the search formula to it so you can pinpoint any errors