Be sure to remember all the arguments in the formula are each with a semicolon; to separate.
The next step asks for the column index.
Here is simply counted. And in the wievielt column of the previously marked table (not the entire worksheet!) Is to be searched for the entry in the field “first name” should.
In our example, it is the third column (in which the first names are). Thus, we simply enter a 3 here.
The last part of our S-reference is not entirely unimportant, because it asks for true = 1 or false = 0.
This is a bit confusing at first, but ultimately means nothing else if Excel should search for exactly the search criterion (as it was entered), or whether it may be similar.
For our example, of course, we are looking for exactly the name entered, and not one of the similar.
So we enter a “0”.
Our finished S-reference for the first field “first name” should look like this.
see picture: (click to enlarge)