2
AssignmentMultiple Choice

Lookup Functions and Formula Auditing

Question 2 • Computer Applications I-Sem A -CA- 39901A

What is the format for the VLOOKUP function?

Answer
A
VLOOKUP(table array, lookup value, range lookup, col index num)
B
VLOOKUP(lookup value, table array, col index num, range lookup)
C
VLOOKUP(col index num, range lookup, table array, lookup value)
D
VLOOKUP(range lookup, table array, lookup value, col index num)