At about the same period as the second form of research () , Excel users have got two new features, "cousins" search (): Hlookup () and Vlookup () .
The primary objective of these two functions was to solve the problem of users who do not understand that this is the last column or row of the matrix that provided the result.
The second objective was to no longer depend on finding the shape of the matrix: Vlookup always performs a search and vertical search Hlookup always horizontal.
The syntax of these functions are = VLOOKUP (value, matrix, no collar) and Hlookup = (value, matrix; No. lig) . The third argument says no (in the matrix) of the column or row that will provide the result.
The algorithm used by these functions is the same as the search function (), presented on February 21.
we see above is an example with a list of names, names and salaries. The objective is, after entering a name in E14 to get the family name and salary in E15 E16. We see in comment forms that were used for this purpose.
Note 1 - We note that the list of names complies alphabetical order: it is essential that the functions search () or rechechev () work well in this example.
Note 2 - The two functions refer to the same matrix D3: F11: This is not a problem because the third article, by specifying the column in question, correct shooting ...
Note 3 - It turns out that Two "Gilles" in this example. According to the algorithm described in the article of February 17, is always the last "Gilles" comes out with the formulas given above.
Note 4 - If for salary, for example, we used the formula = VLOOKUP (E15, E3: F11, 2), it would not work because the column E is in row alphabetically.
We discuss in the next section the possible fourth argument of these two functions, which arrived a few years later still ...
0 comments:
Post a Comment