DATABASE FUNDAMENTALS
HOW TO USE THE CONCATENATE FUNCTION IN EXCEL
|
Question
[CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
|
Which of these Vlookup functions is searching for an exact match?
|
|
=VLOOKUP (True, A2:B6, 2, C16)
|
|
|
= VLOOKUP (C16, A2:B6, 3, TRUE)
|
|
|
=VLOOKUP (C16, A2:B6, 3, FALSE)
|
|
|
=VLOOKUP (C16, A2:B6, 1, $C$4:$D$15)
|
Explanation:
Detailed explanation-1: -Exact match-0/FALSE searches for the exact value in the first column. For example, =VLOOKUP("Smith", A1:B100, 2, FALSE).
Detailed explanation-2: -About the VLOOKUP function The number of the column within your defined range, that contains the return value; 0 or FALSE for an exact match with the value your are looking for; 1 or TRUE for an approximate match.
Detailed explanation-3: -The Syntax of the VLOOKUP Function The function accepts four arguments: lookup value, table array, col index num, and range lookup. The first three are mandatory arguments, while the last one is optional.
There is 1 question to complete.