Excel Tips : How to use VLOOKUP function in Excel ?
What is VLOOKUP in simple words?
When you need to extract data from a table based on a particular value, you can use VLOOKUP to do that. In simple terms, it looks at a table in the first column for a specific value and returns a cell in the same row where you choose the column to return from.
The VLOOKUP function uses the following arguments:
a. Lookup_value (required argument) – Lookup_value specifies the value that we want to look up in the first column of a table.
b. Table_array (required argument) – The table array is the data array that is to be searched. The VLOOKUP function searches in the left-most column of this array.
c. Col_index_num (required argument) – This is an integer, specifying the column number of the supplied table_array, that you want to return a value from.
d. Range_lookup (optional argument) – This defines what this function should return in the event that it does not find an exact match to the lookup_value. The argument can be set to TRUE or FALSE, which means:
i. TRUE – Approximate match, that is, if an exact match is not found, use the closest match below the lookup_value.
ii. FALSE – Exact match, that is, if an exact match not found, then it will return an error.
Please go through the below link for complete demonstration for using VLookup Function :
Blogger Name: Pramod Kumar Kushwaha
For more information & feedback write email at : pktipsonline@gmail.com