VLOOKUP Function:
The VLOOKUP function searches for a value in the first column of a table array and returns a value in the same row from another column in the table array.
The V in VLOOKUP means "Vertical".
Syntax:- =VLOOKUP(value, table_array, index_number, [not_exact_match])
VLOOKUP is used when your comparison values are located in a column to the left of the data that you want to find.
1. The first column must be in alphabetical or numeric order.
2. The VLOOKUP formula has 4 components:
a. Lookup_value: The value to search in the first column of the table array.
b. Table_array: Two or more columns of data. The values in the first column of table_array are the values searched by lookup_value.
c. Col_index_num: The column number in table_array from which the matching value must be returned. A col_index_num of 1 returns the value in the first column in table_array; a col_index_num of 2 returns the value in the second column in table_array, and so on.
d.Range_lookup: A logical value that specifies whether you want VLOOKUP to find an exact match or an approximate match. If TRUE or omitted, an approximate match is returned. In other words, if an exact match is not found, the next largest value that is less than lookup_value is returned. If FALSE, VLOOKUP will find an exact match. If one is not found, the error value #N/A is returned.
3. Enter the formula: =VLOOKUP(A2,H2:I6,2,0)
a. A2 is the look up value.
b. H2:H16 is the range in which you want to find A2 value.
c. 2 is the column number from which matching value which should be returned.
d. 0 stands for exact match.
4. Copy the formula for the rest of the items.
Note:
1- If the range from which the value is being retrieved is not in order then VLOOKUP will not pick some values.
2- To fix it so you will have to freez the range.
3- Now the result will remain same.
The VLOOKUP function searches for a value in the first column of a table array and returns a value in the same row from another column in the table array.
The V in VLOOKUP means "Vertical".
Syntax:- =VLOOKUP(value, table_array, index_number, [not_exact_match])
VLOOKUP is used when your comparison values are located in a column to the left of the data that you want to find.
1. The first column must be in alphabetical or numeric order.
2. The VLOOKUP formula has 4 components:
a. Lookup_value: The value to search in the first column of the table array.
b. Table_array: Two or more columns of data. The values in the first column of table_array are the values searched by lookup_value.
c. Col_index_num: The column number in table_array from which the matching value must be returned. A col_index_num of 1 returns the value in the first column in table_array; a col_index_num of 2 returns the value in the second column in table_array, and so on.
d.Range_lookup: A logical value that specifies whether you want VLOOKUP to find an exact match or an approximate match. If TRUE or omitted, an approximate match is returned. In other words, if an exact match is not found, the next largest value that is less than lookup_value is returned. If FALSE, VLOOKUP will find an exact match. If one is not found, the error value #N/A is returned.
 |
| VLOOKUP Example Image |
a. A2 is the look up value.
b. H2:H16 is the range in which you want to find A2 value.
c. 2 is the column number from which matching value which should be returned.
d. 0 stands for exact match.
4. Copy the formula for the rest of the items.
 |
| VLOOKUP Example Image |
 |
| VLOOKUP Image |
1- If the range from which the value is being retrieved is not in order then VLOOKUP will not pick some values.
2- To fix it so you will have to freez the range.
 |
| VLOOKUP |
3- Now the result will remain same.
 |
| MS Excel VLOOKUP |
Prepare for McAfee MA0-103 exam with our preparation material with full confidence. We offer you 100% real Intel Security Certified Product Specialist-DLPE McAfee MA0-103 exam dumps for your better results. Prepare4Test’s MA0-103 pdf dumps are verified by McAfee Gurus.
ReplyDelete