DATABASE FUNDAMENTALS
USING THE RIGHT LEFT AND MID FUNCTIONS IN EXCEL
|
Question
[CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
|
The correct way to write the VLOOKUP formula below is ____
|
|
VLOOKUP(A3, G2:h5, 2;0)
|
|
|
=VLOOKUP(A3, G2;h5, 2, 0)
|
|
|
=VLOOKUP(A3, G2:h5, 0)
|
|
|
= halwq (a, ja: hh, a, 0)
|
|
|
=VLOOKUP(A3, G2:h5, 2, 0)
|
Explanation:
Detailed explanation-1: -=VLOOKUP(lookup value, range containing the lookup value, the column number in the range containing the return value, Approximate match (TRUE) or Exact match (FALSE)).
There is 1 question to complete.