Vlookup The super time saver
Everyone knows about excel and it's
usefulness in each and every part of business that how important is excel is.
from basic plus minus to high degree of calculation excel can do in just
seconds. Excel is a Deep ocean the deeper you want to go the deep you will go
inside it, excel is a never ending ocean.Excel have a function which is called
vlookup it is an extremely Useful function of excel, this function performs a
vertical lookup by searching for a value in the first column of a table and
returning the value in the same row in the index_number position.
The VLOOKUP function is a built-in function in Excel that is
categorized as a Lookup/Reference Function. It can be used as a worksheet
function (WS) in Excel. As a worksheet function, the VLOOKUP function can be
entered as part of a formula in a cell of a worksheet.
The VLOOKUP function is actually quite easy to use once you
understand how it works! If you want to follow along with this tutorial,
download the example spreadsheet.
The formula looks like this :
VLOOKUP(
value, table, index_number, [approximate_match] )
Parameters or Arguments
value
The value to search for in the first column of
the table.
table
Two or more columns of data that is sorted in
ascending order.
index_number
The column number in table from which the
matching value must be returned. The first column is 1.
approximate_match
Optional. Enter FALSE to find an exact match. Enter
TRUE to find an approximate match. If this parameter is omitted, TRUE is the
default.
Returns
The VLOOKUP function returns any datatype such as a string,
numeric, date, etc.
If you specify FALSE for the approximate_match parameter and no exact match is found, then the VLOOKUP function will return #N/A.
If you specify TRUE for the approximate_match parameter and no exact match is found, then the next smaller value is returned.
If index_number is less than 1, the VLOOKUP function will return #VALUE!.
If index_number is greater than the number of columns in table, the VLOOKUP function will return #REF!.
If you specify FALSE for the approximate_match parameter and no exact match is found, then the VLOOKUP function will return #N/A.
If you specify TRUE for the approximate_match parameter and no exact match is found, then the next smaller value is returned.
If index_number is less than 1, the VLOOKUP function will return #VALUE!.
If index_number is greater than the number of columns in table, the VLOOKUP function will return #REF!.
Comments
Post a Comment