Hello friends today we will discuss about vlookup formula in excel. vlookup formula is one most important formula in excel. Today I will tell you to easy way to use vlookup formula. I hope that will you really enjoy this.
What is Vlookup formula in excel?
When you want to search specific information in your excel worksheet, then you use vlookup formula. Below image show that how to create a specific data to using vlookup formula.
Explaination of vlookup formula
Vlookup formula is =VLOOKUP (lookup_value, table_array, col_index_num, [range_lookup]
Lookup value- In lookup value shows the cell where you want to see lookup value.
Table array-Table array is a range of the cell in which you see the lookup value. Below image shows that the example of the table array. In this image you see that the selected range of the data is called table array.
Column index number- column index number shows that the column number where you put the vlookup formula in cell.
Range lookup-it is a optional option where you want to fill true or false. True means that approx match the value and False means that exact match the value.
How many ways to open vlookup formula in excel?
There are two way to find vlookup formula in excel spreadsheet.
1. Go to formula tab, in function library group you see lookup& reference click on it, again you see vlookup formula option click on it and use this formula
2.Click the cell where you want to use this formula and type =vlookup(lookup_value, table_array, Col_index_num, range_lookup)
How to use vlookup formula in ms excel?
As we know that When you want to search specific information in your excel worksheet, then you use vlookup formula. Suppose you have range of the data and you want to show specific information then use vlookup formula.
Step 1- Go to the cell, where you want to use this formula
Step 2- Put the formula =vlookup(lookup_value, table_array, Col_index_num, range_lookup)
In lookup value put the cell where you want to see lookup value
In table array select the range of the data
In column index number put column number
In range lookup you want to fill true or false. True means that approx match the value and False means that exact match the value when you have done this work press enter.
If you want to see more example Microsoft office official website.
In this tutorial you have learn about the vlookup formula in excel. If you found any mistake or missing in this tutorial than let me know through your comment. And if you like this article doesn’t forget to like my page on Facebook and also follow me on twitter.
People also read:- Filter in excel.
People also read:- consolidate in excel.
What is Vlookup formula in excel?
When you want to search specific information in your excel worksheet, then you use vlookup formula. Below image show that how to create a specific data to using vlookup formula.
Vlookup formula is =VLOOKUP (lookup_value, table_array, col_index_num, [range_lookup]
Lookup value- In lookup value shows the cell where you want to see lookup value.
Table array-Table array is a range of the cell in which you see the lookup value. Below image shows that the example of the table array. In this image you see that the selected range of the data is called table array.
Column index number- column index number shows that the column number where you put the vlookup formula in cell.
Range lookup-it is a optional option where you want to fill true or false. True means that approx match the value and False means that exact match the value.
How many ways to open vlookup formula in excel?
There are two way to find vlookup formula in excel spreadsheet.
1. Go to formula tab, in function library group you see lookup& reference click on it, again you see vlookup formula option click on it and use this formula
How to use vlookup formula in ms excel?
As we know that When you want to search specific information in your excel worksheet, then you use vlookup formula. Suppose you have range of the data and you want to show specific information then use vlookup formula.
Step 1- Go to the cell, where you want to use this formula
Step 2- Put the formula =vlookup(lookup_value, table_array, Col_index_num, range_lookup)
In lookup value put the cell where you want to see lookup value
In table array select the range of the data
In column index number put column number
In range lookup you want to fill true or false. True means that approx match the value and False means that exact match the value when you have done this work press enter.
In this tutorial you have learn about the vlookup formula in excel. If you found any mistake or missing in this tutorial than let me know through your comment. And if you like this article doesn’t forget to like my page on Facebook and also follow me on twitter.
People also read:- Filter in excel.
People also read:- consolidate in excel.
0 comments:
Post a Comment