How to create a Finder in Excel - Excel Data Finder

The well-known Microsoft Office Excel tool is a must-have in virtually every office around the world. This particular tool allows a multitude of functions, so knowing how to create a search engine in Excel is one of those things you need to know to make the app easier to use.

In any case, the process that we are going to teach you today should not be confused with the find words in a range or range of cells and highlight them in Excel , on the other hand, the one indicated is also a perfectly possible process.

As we indicated previously, with Excel the functions of the work are facilitated, with this useful tool we can organize huge amounts of information , make complicated calculations in an instant and observe the development of our work or our company.

In this tutorial, we are going to learn how to create an internal search engine that further squeezes all the great features we have in Excel , an action that adds to the finding values ​​and looking for a number in a column , can be very useful for maintaining order in your tables.

How to create a search engine in Excel

To create a search engine in Excel, it you must first have an organized table. This type of search engine is used precisely to search for specific data in databases of considerable length.

To create a search engine in a table, do the following:

There are many ways to create a search engine in Excel , however, the following method is applicable in virtually all types of tables. Today we are going to focus on the most basic data tables, but it is also possible to find data in two or more Excel sheets .

Create a Finder in Excel (part one)

• This time, we'll focus on a basic user data table. Our objective will be to seize the code of the user (which for other purposes might well be the DNI, ID card or ID card number) so that the user's information is displayed, which in this case will be the name and date of birth .
• The first step is to create a header similar to the one that integrates the data, in our case it would be to create one that includes the columns Code, Name and Date of birth, somewhere else in the table. For convenience, we will choose in column F, but the location does not matter, you can choose the one that looks best to you.
• The next step is to open the Formulas option. In this tab you have to open Research and referral .

Create a Finder in Excel (part two)

• In Search and Reference is the formula we need for " To research", click on it. A new tab will appear which presents us with two options, select the valeur desired : Vector .
• Here are three factors you need to set: Lookup_Value, Compare_Vector, and Result_Vector.
• The value sought is the object of research, in this case, it is the code. Click on the empty space to Search_Value then on the table where you will write to search. In our case, that would be right below the additional header we created, specifically under the section -- .
• The comparison value, as the name suggests, is the value that will be compared to the search value. In this case, we are interested in user codes. For this reason, you must select all existing user codes here. Slide from first to last.
• The result value is what will be displayed after entering and comparing a code. In this case, we'll need the name. Therefore, select the entire name column and click OK .
• After that, when looking for a value, in this case a user code, the name of said user will be reflected in our new header.

You can also apply the search engine to other columns

• To show us information from other columns, just copy the formula and rethink it. In this case, you need to copy the Name formula, which is the one we will use in the column Date of Birth .
• We're going to copy this formula, which in our case should be something like "LOOKUP (F3; TABLE2 [CODE]; 3TABLE2 [NAME])", then continue pasting it into the data de birth of the new header.
• After that, change the name to "= SEARCH (F3; TABLE2 [CODE]; TABLE2 [DATE OF BIRTH])".
• By doing this process, when writing a user's code, the name and date of birth information will appear. To larger tables, the procedure is the same, you can change the formula, but still changing the second value, i.e. the result.

With the previous tutorial on creating a Finder in Excel , you can easily access data from large tables. It is particularly useful for databases of considerable length, such as payroll or student grades. Apply this useful Excel tool now!

In turn, the using the VLOOKUP or HLOOKUP function in an Excel worksheet is generally very useful for expanding its capabilities while using this popular app, as it is relatively similar to the function we discussed in the previous guide.