Which of the following is the correct VLOOKUP formula?
VLOOKUP(range)
VLOOKUP(value, range)
VLOOKUP(value, range, result_column, exact_match)
None of the Above
Answers
The VLOOKUP(value, range, result_column, exact_match) is correct.
Explanation:
The Syntax for VLOOKUP is VLOOKUP (Lookup Value, Table Array, Column Index, [Range Lookup})
The Microsoft Excel VLOOKUP function comprises of the following four arguments.
a) The criteria value to be searched from the farthest left column (Lookup value)
b) The selected lookup table cells range (Table Array)
c) The column number for retrieve output result (Column Index)
d) The match mode (Range Lookup, TRUE = approximate match, FALSE = exact match)
Vlookup Syntax: VLOOKUP (value, table, index number, [approximate_match])
Explanation:
Vlookup Syntax: VLOOKUP (value, table, index number, [approximate_match])
Syntax or argument description:
Value - It is used to look the first column in a table
Table - A table to read the value
Index_number - A table column is used to retrieve the value
Approximate_match - If this parameter is ignored, the default value is TRUE then Exact match (FASLE) and approximate match (TRUE)
Vlookup Syntax: VLOOKUP (value, table, index number, [approximate_match])
To learn more...
brainly.in/question/14986797