Add SearchBox in Excel

Post Reply
administrator
Site Admin
Posts: 82
Joined: Mon Dec 03, 2018 10:35 am

Add SearchBox in Excel

Post by administrator » Wed Aug 09, 2023 11:38 am

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

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:
Image

Another option in the menu appears.
Click on Table Design and enter a Table Name:
Image
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 29 times
ExcelSearchBox.xlsx
Example File
(16.79 KiB) Downloaded 29 times
Attachments
Add Table Name
Add Table Name
Format as Table
Format as Table
Preview
Preview

Post Reply

Who is online

Users browsing this forum: No registered users and 0 guests