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.