What are sintex of vlookup function

Question

Accepted Answer

VLOOKUP is a function in Excel that searches for a specific value in a table and returns a corresponding value from another column.

Syntax: VLOOKUP(lookup_value, table_array, col_index_num, [range_lookup])
lookup_value: The value to search for in the first column of the table_array.
table_array: The table of information in which data is looked up.
col_index_num: The column number in the table_array from which the matching value should be returned.
range_lookup: Optional. A logical value that specifies whether you want VLOOKUP to find an exact match or an approximate match.
Example: VLOOKUP(1234, A2:B26, 2, FALSE) will search for the value 1234 in column A and return the corresponding value from column B.

Popular interview questions of MIS Executive