NEW
Font size
WorksheetsUnderstand VLOOKUP and INDEX MATCH
Total questions: 10
Worksheet time: 5mins
Which of the formulas below contain the correct syntax (formula arguments) for the VLOOKUP function?
=VLOOKUP(lookup_value, table_array, col_index_num, range_lookup)
=VLOOKUP(table_array, lookup_value, col_index_num, range_lookup)
=VLOOKUP(lookup_value, table_array, col_index_num, table range)
Which of the following is NOT possible with VLOOKUP?
You can lookup values located in a different worksheet.
You can lookup values located in a column to the left of the column that contains the lookup value.
You can lookup values such as text, numbers or characters.
In a VLOOKUP formula, what does the argument column_index_number mean?
This is the secret INDEX number that each column in an Excel worksheet has.
This is the number of the column within the selected table_array where the lookup result is located.
This is numbers you assign to columns in your worksheet.
What type of result does the MATCH function, when used on its own, return?
It returns the lookup value located in a specific location.
It returns a value that is the same as the lookup value.
It returns the relative position of a lookup value, either as a row or column number, within the selected array.
From the above table, what is the correct VLOOKUP formula should be fill in the highlight box?
=VLOOKUP(A15,A4:D11,4,FALSE)
=VLOOKUP(B15,A4:D11,4,FALSE)
=VLOOKUP(A15,D4:D11,4,FALSE)
We can use VLOOKUP for the following EXCEPT?
Search tables and database
Sum up all the database
Tax and commission rate calculation
Which of the formula is correct about INDEX & MATCH function?
=INDEX(Lookup Range,MATCH(Lookup Value, Return Range, 0))
=INDEX(Return Range,MATCH(Lookup Range, Lookup Value, 0))
=INDEX(Return Range,MATCH(Lookup Value, Lookup Range, 0))
Does Index & Match formula breaks up when a column is inserted?
YES
NO
Which sentence is NOT correct about the differences between VLOOKUP and INDEX MATCH formula?
Dynamic Column Reference
Lookup Value Size Limit
Both can look from Right to Left
From the above table, what is the correct INDEX & MATCH formula should be fill in the highlight box?
=INDEX(A14,MATCH(D3:D10,A3:A10,0))
=INDEX(D3:D10,MATCH(A14,A3:A10,0))
=INDEX(D3:D10,MATCH(A3:A10,A14,0))
