Excel Vlookup formula, In this era of developing times
Teknoto.Net - Excel Vlookup formula, In this era of developing times, technology support plays an important role in helping the learning and working process, one of which is Microsoft Excel. Yes, the application on this computer is indeed familiar to all of us, because we know exactly what this application looks like. And to operate it in general, Excel has formulas to make it easier to manage every data that is done. One of the frequently used formulas is “Vlookup”.
What is the Vlookup formula and what are the complete specifications? Let's just take a look at our explanation below about the Excel Vlookup Formula that you can learn at home.
The Vlookup formula is a formula in Microsoft Excel that is generally used to retrieve a value in a source table which will be used as a reference in a table that is being analyzed. This formula itself is very popular because most people think this formula is a basic formula that needs to be learned if you work in a company by relying on the excel program.
Using the excel vlookup formula can be an alternative when we have difficulty using the IF function with many conditions and criteria.
How to Write Excel Vlookup Formulas
Vlookup = Vlookup formula to retrieve data vertically
Lookup_value= is the value of the result which will later match the value contained in table_array
Table_array = is the source to be input data
Col_index_num= is a column number in table_array
Range_lookup= one of the lookup methods in the source table with a value of TRUE you can write “1” or FLase which you can write “0”
Use of Vlookup Formulas
In the above review there we will be asked to fill in the salary and bonus fields by taking from the data in the source array using the vlookup function. In the table above, we can also see the analysis first before finally writing the formula in the salary and bonus column. The things you need to know from this formula include:
Lookup Value: is the thing on the left in the array table and this case is the column group whose value will be matched.
Column Index Number: This is a method that starts in the leftmost column to the right.
Range lookup: This is a way of looking up data, the value is between True and False. If we use false, it means that if the data in the array table is not found or there is no match, then a N/A error will be displayed, but if we use TRUE here, when the data is not found, the closest value will be displayed indirectly.
How to Get Started with Vlookup Formulas
There are four pieces of information needed to build the Vlookup syntax.
1. . First you need to find the desired value or commonly called the search value
2. The second is about where the value for the search is located. Keep in mind, friends, that the lookup value needs to be in the first column with the range for Vlookup to work properly.
3. The third is the column number that is in the range with the contents of the return value.
4. Finally, if you look at it from an optional point of view, here we can specify TRUE if we want a close result or FALSE if we want a similar result from the return value. Even if you don't specify anything, the default value will always be TRUE or the result will be close.
Thus the review above, hopefully, useful and see you again