What is VLOOKUP?
Hello all, We are back with the most interesting and useful tool for the MS Excel, you might be searching for.Vlookup is a great tool for MS EXCEL, that helps us in looking up the desired data from the tables in seconds.Vlookup searches for the information vertically into columns and returns the desired value in the same row. It saves our time and maintains the accuracy of the data so needed.
How can we use VLOOKUP Function??
There are four arguments you need to put up inside the parenthesis of VLOOKUP function, but before that, you need to know the syntax of it.
=VLOOKUP(“Vlookup Value”,Range,Column Number ,Match)
Let us discuss these arguments in detail below,
1. VLOOKUP VALUE: This is the name of the item you are looking for, it can be anything from your table and as it is in text format, it would be enclosed by double quotes.
2. RANGE : This is the cell that contains the data,that is like you start your table from cell or column A and its row 2 and end your table at column B and its row 20,then you will write your range as,”A2: B20″, where colon separates the ‘range from’ and ‘range to’ as arguments.
3. COLUMN NUMBER: Column number is the column which contains your answer or can say which contains your return value like you are searching for the price of any item, then column number here would be the number of that column which contains prices of different items.
4. MATCH: It is an Optional Argument, which describes to the VLOOKUP Function of Excel, to look up either for an Approximate match of user’s request or for the Exact match.If you want an Exact Match you can specify “FALSE” in the argument, otherwise “TRUE” for an Approximate Match.By default, VLOOKUP takes TRUE as an argument.
How VLOOKUP Function works practically?
Now, Let us do an example to implement VLOOKUP Function on our own,
Consider this Spreadsheet, there are five columns as Supplier ID, Part Number, Part Name, Part Price and Status.Let us say we need to look up If we have “Oil pan” in stock or not.
Let’s write lookup function step by step for it,
NOTE: We can write the VLOOKUP Function in any blank cell of the SpreadSheet.
1. VLOOKUP VALUE: For the Problem, we are given, we need to specify Oil pan as our Vlookup Value in double quotes, So we can write it as,
2. RANGE: Now, we need to specify our range, as we can see our table starts from A2 and ends in E11, So we can write it as,
3. COLUMN NUMBER: The Return Value we are expecting is, either the item is “In stock or not”, that is we are looking for the Status of the Oil pan, which is column number 5. So, We would specify it as,
4. MATCH: Now, this is an optional argument of VLOOKUP Function, So let us specify it as Exact Match, that is False and close the parenthesis of VLOOKUP Function.
Now, Press the Enter Button and you will get your result as “Out of Stock”.
This is how you can manage your Complex Spread Sheets to frequently get the results using VLOOKUP Function.Practice it on easy tables first and then try to Implement on Complex ones.
Bookmark this website for more useful Information and tips related to Excel Queries and share with your Colleagues and Friends who are facing problem in understanding and implementing Excel Functions.If you have any question regarding this post then you can freely post it to us, We’ll be happy to answer you.