Learn Excel VLOOKUP with Multiple sheets | Hindi
- 6 лет назад
Learn Excel VLOOKUP with Multiple sheets | Hindi\r
\r
\r
VLOOKUP (lookup_value, table_array, col_index_num, [range_lookup])\r
\r
lookup_value (required)\r
\r
The value you want to look up. The value you want to look up must be in the first column of the range of cells you specify in table-array\r
\r
.table_array (required)\r
\r
The range of cells in which the VLOOKUP will search for the lookup_value and the return value.\r
\r
col_index_num (required)\r
\r
The column number (starting with 1 for the left-most column of table-array) that contains the return value.\r
\r
range_lookup (optional)\r
\r
A logical value that specifies whether you want VLOOKUP to find an ex match or an approximate match:\r
\r
TRUE assumes the first column in the table is sorted either numerically or alphabetically, and will then search for the closest value. This is the default method if you dont specify one.\r
\r
FALSE searches for the ex value in the first column.\r
Multiple Worksheet interconnected VLOOKUP()\r
\r
To watch more videos visit: \r
To Buy a Excel Course Pen drive visit: \r
Like us on Facebook: \r
Subscribe to the Channel:
\r
\r
VLOOKUP (lookup_value, table_array, col_index_num, [range_lookup])\r
\r
lookup_value (required)\r
\r
The value you want to look up. The value you want to look up must be in the first column of the range of cells you specify in table-array\r
\r
.table_array (required)\r
\r
The range of cells in which the VLOOKUP will search for the lookup_value and the return value.\r
\r
col_index_num (required)\r
\r
The column number (starting with 1 for the left-most column of table-array) that contains the return value.\r
\r
range_lookup (optional)\r
\r
A logical value that specifies whether you want VLOOKUP to find an ex match or an approximate match:\r
\r
TRUE assumes the first column in the table is sorted either numerically or alphabetically, and will then search for the closest value. This is the default method if you dont specify one.\r
\r
FALSE searches for the ex value in the first column.\r
Multiple Worksheet interconnected VLOOKUP()\r
\r
To watch more videos visit: \r
To Buy a Excel Course Pen drive visit: \r
Like us on Facebook: \r
Subscribe to the Channel: