For those who get the hang of using Excel and now the transition from the use of the “fundamental basis” was for “less fundamental”, VLOOKUP is a must-try, must-know and must-use functions.

But how do you use VLOOKUP in Excel? One of the questions. I believe what should be asked is “how does this function work?” V in VLOOKUP stands for vertical – rather than “value,” as many would initially think.

Syntax VLOOKUP is VLOOKUP (lookup_value, table_array, col_index_num, range_lookup).
lookup_value – what you’ll find in the first column of a table_array.
table_array – two or more columns of data that can be text values ??in the upper or lower (no matter the case of text), numbers or other logical values??.

Simply put, syntax tells Excel to use VLOOKUP to return the value of the index number of a particular column of the table array positioned at the same row with the value in the first column corresponding to the lookup value (which is our criterion) and whether the match should be exact.

Notes about the VLOOKUP and limitations:

-It just returns the value associated with the first game. That is, if you have more than one value that matches the search criteria, the values ??of the second and final match will be ignored.

-Results will be # NA if no match is found.

-When searching text values ??in the first column table_array, ensure that the data in the first column table_array does not have leading spaces, trailing spaces, inconsistent use of straight (‘or “) and curly (‘ or”) quotation marks.

-The formula will give you # REF if the column index number you specify is less than 1 (there is no column number 0 or negative) or greater than the number of columns the table has an array.

Be Sociable, Share!

•