Add SearchBox in Excel

[administrator]

When you want to search in Excel you can use CTRL-F but you could use a SearchBox:


When you've created an Excel sheet with multiple tabs, select a tab and click in the first field.
Now click on HOME --> Format as Table:


Another option in the menu appears.
Click on Table Design and enter a Table Name:

Based on each table name you can create a searchbox now:

In the first tab select the field that should make your search visible and enter:

=IFERROR(FILTER(VSTACK(EU;ASIAN;USA);ISNUMBER(SEARCH($B$2;VSTACK(EU;ASIAN;USA))));"No Value")

Keep in mind that in the example we use the table names:

• EU
• ASIAN
• USA

And use field B2 for the searchtext.

ExcelSearchBox.xlsx

Example File

(16.79 KiB) Downloaded 30 times

ExcelSearchBox.xlsx

Example File

(16.79 KiB) Downloaded 30 times