Excel VLOOKUP for everyone !!!

Everyone must know the use of VLOOKUP function in excel when you need to find things in a table or a range by row. All most all the industry and the profession have to come across the data, VLOOKUP function is a great tool for data analysis and can bring back corresponding values from a big data set on the fly for multiple values. You can bring back values either from different spreadsheets or different workbooks seamlessly. VLOOKUP function can make your analysis task quite easy and quick.

Example:

Lets say Column 1 has values     Column 2 has values in first excel sheet

                A                                50   

                B                                60

                C                                70

Then you have a separate excel sheet where you need the value of column 2 against C in the the 1st excel sheet . 

Then type =VLOOKUP (select the cell where "C" exist in the separate excel, then go to first excel and select the full range from, give the reference cell as 2, false)

System will search the value against C in the first excel and return 70 in the separate excel where it is required against "C"

The VLOOKUP function uses the following arguments:

1. Lookup_value (required argument) – Lookup_value sp
2. ecifies the value that we want to look up in the first column of a table.
3. 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.
4. Col_index_num (required argument) – This is an integer, specifying the column number of the supplied table_a
5. rray, that you want to return a value from.
6. 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:
   • TRUE – Approximate match, that is, if an exact match is not found, use the closest match below the lookup_value.
   • FALSE – Exact match, that is, if an exact match not found, then it will return an error.

Note: the Boolean FALSE (fourth argument) tells the VLOOKUP function to return an exact match. If the VLOOKUP function cannot find the value in the first column, it will return a #N/A error.

Please watch this video til the end which describes the steps for the VLOOKUP.