Excel vertical search function
This is a feature that many people don't understand or have a hard time with.
We think the formula =find is the most important function in Excel. Why?
Because once you learn the =translation function, you will feel more confident when dealing with large data sets.
This confidence will lead you to learn the other intermediate functions, which are =If(), =Compare(), and =Offset().
Becoming fluent in these features will have a transformative effect on your Excel proficiency and confidence in working with data.
In this video we will quickly look up the remaining amount of a person based on an example.
The download file can be found HERE
Before we start using the vertical search function, let's have a brief info.
What do we actually need for the vertical search function?
1. Need a search value
2. Need a table array or full data value we're going to look at.
3. column index number
[4.] As an extra, we can also use the approximate option.
What does all this actually mean?
1. The search value is what we want to look up from which we will then display a certain result.
2.The table array is actually the range that the lookup values and lookup results are in.
But keep in mind that the search values must always be on the left side of the first column in the selected table matrix.
3.The column index number is actually the number of the column where the search result will be located.
[4.] The Approximate Option:
is the return value true or false.
With this option we are actually going to indicate that it is “not exactly matched” or “exact match”. This option is not mandatory!
To ensure that your search value runs smoothly, it is recommended to create a selection list (Dropdown menu).
This will ensure that the user cannot enter typos or other data, so that the search value will not work.
Best of luck!
Did you find this video interesting?
Would you like to make a small donation?
Thanks in advance.
Video index :
00:00 Inleiding
00:32 Voorbereiding voor vind.speciaal
00:48 Maken van vind speciaal functie (=Vind.spec ) met 1 waarde
01:53 Naar de volgde waarde gaan met vind.spec
02:32 Wat kan een fout zijn bij vind.spec?
02:50 Als.fout & Vind.spec combineren
04:01 Voorbereidingen voor tekst te gaan splitsen
04:08 Gebruik maken van de Links functie
04:50 Gebruik maken van de Deel functie
06:58 Als.fout & Deel combineren
08:17 Functies omzetten naar gewone tekstwaarde
08:29 Gebruik maken van plak speciaal
09:03 Rijen en kolommen automatisch aanpassen aan inhoud grote