This will search for the given Region name in column A (A2:A6) and return the corresponding value in the Column B (B2:B6). Syntax: =VLOOKUP(lookup_value, Range, 2, TRUE)Р”В®xample: =VLOOKUP(РІР‚СљSomeРІР‚Сњ, Range(РІР‚СљA2:B6РІР‚Сњ, 2, FALSE) VLookUp Syntax to Return Approximate Match:Р”Р‡ollowing is the Syntax and Example to search for a value in the target array and return the corresponding value in the 2nd column. This will find the RegionРІР‚СњNorthРІР‚Сњ in Column A (A2:A6) and return the corresponding value in the Column B (B2:B6). Syntax: =VLOOKUP(lookup_value, Range, 2, FALSE)Р”В®xample: =VLOOKUP(РІР‚СљNorthРІР‚Сњ, Range(РІР‚СљA2:B6РІР‚Сњ, 2, FALSE) VLookUp Syntax to Return Exact Match:Р”Р‡ollowing is the Syntax and Example to search for a value in a range and return the value in the 2nd column. 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. Here is the Syntax of VlookUp explained with Examples. (If this parameter is omitted, TRUE is the default). TRUE returns the value of an approximate match. You can enter False to search for exact match and return the corresponding value. approximate_match: An Optional Parameter to Specify whether you want perform an exact match or an approximate match.col_index_num: Column number in the target Range, Table or An Array from which the Corresponding matching value lookup_value to be returned.Table_array could be a Range,Named Range, Table or an Array. This is the array in which you are looking for the lookup_value. table_array: Range, Table or An Array with one or multiple columns.lookup value could be a value, string, date, cell reference, named range. lookup_value: The value to find in the first column of the range, array or table.lookup value, table array, index number and range lookup.

=VLOOKUP(lookup_value, table_array, col_index_num, ) Parameters VLookUp have 3 required parameters and one optional parameter. =VLOOKUP(Value to Find, Target Range, Table or Array, Index Column Number, Exact or Approximate Match Type) SyntaxР”Р‡ollowing is the Syntax of the Excel VlookUp function. And return the respective column value of the matching position. Here is the VLOOKUP function in Excel to lookup for a value in a Range, Array or Table. It performs the vertical lookup from left to right columns of a table. VLookup match the given lookup value in the first column of the target range and returns the corresponding value of the specified column. VLOOKUP Function in Excel helps to lookup the corresponding values of a Range,Table and Arrays.

Vlookup in excel 2016 for dummies