Vlookup function

[udoy120]

This function is well known. It allows us to search for data using two indexes from different sources, and if they match, obtain the value we were looking for.

In this example our indexes will be the dates and when they hong kong phone number libraryC match, we will obtain the numerical value associated with that date.



Vlookup function
Vlookup function


=Vlookup(A2:A; D2:E; 2; FALSE)
In the first parameter of the function (A2:A), we indicate the index of the first data source.

In the second parameter (D2:E), we indicate the range of the source from which we want to obtain the data where the first column will be the index, in this case the index corresponds to column D.

In the third parameter we indicate the number of the column of data we want to obtain. In our case it corresponds to the number two, since the number 1 corresponds to column D, 2 to E and so on.

In the last parameter we indicate whether the data source where we are going to obtain information is sorted or not. If we indicate that it is sorted and the index value is not found, then the result closest to the corresponding index will be returned. On the other hand, if we indicate that it is not sorted and a result is not found, an error will be returned.