How can you combine the comparison function and the shift function?

In the previous videos, the shift function and the comparison function were already discussed separately.

Have you not seen these yet or are you not yet familiar with these functions?

Be sure to take a look at the links below first:

​

​ View the Shift function

View the Compare function

​

In this video we are going to combine these 2 functions.

Be sure to use the download file so you can collaborate with me during the video.

Download file HERE

​

Chapters index :

​

00:00 Introduction

02:32 Beginning of function build-up

03:00 The 1st comparison function(vertical)

04:00 The 2nd comparison function (horizontal)

04:55 shift function

06:10 Testing and decision

Combining these functions will ensure that you will quickly find a value in a large data list.

And this by using multiple selection criteria.

In our example we do this on the basis of 2 selection lists (drop down menus), from which the user can select.

Do you not yet know how to create a selection list (Drop down)?

View Static dropdown

View Dynamic dropdown

​

Keep practicing and good luck

Did you find this video interesting?

Would you like to make a small donation?

Thanks in advance.