Скачать или смотреть Excel - Search Multiple Sheets with ONE Formula

This is how to easily and dynamically search through multiple sheets in your Excel workbook and return all the results in one large search result array.

We'll use the VSTACK, FILTER, and SEARCH functions to do this.

Join my free newsletter now: https://www.gotsheet.xyz/c/gotsheet-y...

Here's the function I used:

=VSTACK(
FILTER(Data1, ISNUMBER(SEARCH(C2, Data1[company]))),
FILTER(Data2, ISNUMBER(SEARCH(C2, Data2[company]))),
FILTER(Data3, ISNUMBER(SEARCH(C2, Data3[company])))
)

=============================
Starting a Newsletter? Check out Beehiiv with a free trial and 20% off your first 3 months: https://www.beehiiv.com/partners/got-...

Tools I can't live without: https://amzn.to/4gL5SZ4

I receive commission on purchases made through some links on this page
=============================

Find Eamonn
on LinkedIn:   / eamonncottrell  
on Twitter:   / eamonncottrell  

=============================