What is the purpose of range lookup in VLOOKUP lookup_value table_array Col_index_num range_lookup?
Skip to content
Show
VLOOKUP Function in ExcelVLOOKUP Function in Excel helps to lookup the corresponding values of a Range,Table and Arrays. VLookup match the given lookup value in the first column of the target range and returns the corresponding value of the specified column. It performs the vertical lookup from left to right columns of a table. In this topic:
VLOOKUP FunctionHere is the VLOOKUP function in Excel to lookup for a value in a Range, Array or Table. And return the respective column value of the matching position.
SyntaxFollowing is the Syntax of the Excel VlookUp function. VLookUp have 3 required parameters and one optional parameter.
ParametersVlookUp function takes four parameters. lookup value, table array, index number and range lookup.
Syntax ExamplesHere is the Syntax of VlookUp explained with Examples. We can use VLookUp function to find a value in the left most column of the table array and return the corresponding value of the given column. 1. VLookUp Syntax to Return Exact Match:Following is the Syntax and Example to search for a value in a range and return the value in the 2nd column. Syntax: =VLOOKUP(lookup_value, Range, 2, FALSE) Example: =VLOOKUP(“North”, Range(“A2:B6”, 2, FALSE) ‘OR =VLOOKUP(D2, Range(“A2:B6″, 2, FALSE) This will find the Region”North” in Column A (A2:A6) and return the corresponding value in the Column B (B2:B6). It will return #NA if it finds no match. 2. VLookUp Syntax to Return Approximate Match:Following is the Syntax and Example to search for a value in the target array and return the corresponding value in the 2nd column. Syntax: =VLOOKUP(lookup_value, Range, 2, TRUE) Example: =VLOOKUP(“Some”, Range(“A2:B6”, 2, FALSE) This will search for the given Region name in column A (A2:A6) and return the corresponding value in the Column B (B2:B6). It will return approximate search result if it finds no match. PurposeVLOOKUP Function is one of the most using and powerful formulas in the Excel. Often, we search for a value in a array of values and find the corresponding value for further process. For example, we can find Sales of a given Department. We can search for a name in the huge directory and list the respective column values in a range.
VLOOKUP Usage Steps & InstructionsMany Excel Users wants to understand How to Use VlookUp? Here are the Simple instructions and Examples to explain the usage of VLOOKUP Function in nutshell. We can specify the lookup value, lookup range, lookup column and match type to return the matched values.
Here is the Example File, VlookUp function is explained with Syntax, Examples and Uses with Simple Step by Step Instructions. Return ValuesVLOOKUP Function return the Following Values when you pass the arguments to the Function.
Best PracticesHere are the best practices to be followed while using Excel Vlookup Function.
Points to Remember:Please remember and note the following Points while using Excel Vlookup Formula. Understanding the below points will help you to avoid Issue and troubleshooting the Formula.
FormulasExamplesVLOOKUP Formula with Example Download Example FilesRecommended Topics:
Related Functions:In most scenarios, we use VLookUp function with the following Excel formulas
Share This Story, Choose Your Platform!© Copyright 2012 – 2020 | Excelx.com | All Rights Reserved Page load linkWhat is the purpose of range lookup in VLOOKUP?The range of cells in which the VLOOKUP will search for the lookup_value and the return value. You can use a named range or a table, and you can use names in the argument instead of cell references.
What does col_index_num mean in VLOOKUP?The col_index_num is the column of data that contains the answer that you want. If your table is set up as: column 1 - Student ID Number, column 2 - Student Names, column 3 - Grades and you inputted a Student ID Number and you want to retrieve the grade that was received for that person, the col_index_num would be 3.
What does lookup_value mean?A value that LOOKUP searches for in an array. The lookup_value argument can be a number, text, a logical value, or a name or reference that refers to a value. If LOOKUP can't find the value of lookup_value, it uses the largest value in the array that is less than or equal to lookup_value.
What is the table_array argument?When you create a VLOOKUP or HLOOKUP function, you enter a range of cells, such as D2:F39. That range is called the table_array argument, and an argument is simply a piece of data that a function needs in order to run. In this case, the function searches those cells for the data you're trying to find.
|