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.