All of the following statements are TRUE about the VLOOKUP function EXCEPT:
A) The HLOOKUP function is the more commonly used than the VLOOKUP function.
B) The "V" in VLOOKUP stands for vertical and is used when your comparison values are located in a column or vertically to the left of the data that you want to find.
C) You can use to look up a value and then, using that value as a reference, return data that is associated with that value.
D) VLOOKUP functions are extremely valuable when working with tables where the data is in columns.
Correct Answer:
Verified
Q18: AND,OR,and NOT are examples of Excel _
Q19: All of the following statements are TRUE
Q20: Which of the following is an example
Q21: The _ function allows for multiple criteria
Q22: Which of the following is the correct
Q24: If the VLOOKUP range_lookup argument has the
Q25: The first argument of the AVERAGEIFS function
Q26: The _ function is a useful tool
Q27: The third argument of the VLOOKUP function
Q28: The first argument of the AVERAGEIF function
Unlock this Answer For Free Now!
View this answer and more for free by performing one of the following actions
Scan the QR code to install the App and get 2 free unlocks
Unlock quizzes for free by uploading documents