When you use a lookup type of TRUE, the VLOOKUP function looks only for an exact match of the lookup value.
Correct Answer:
Verified
Q12: A data list that categorizes values you
Q13: A vertical lookup table is a lookup
Q14: When you write a VLOOKUP formula, you
Q15: Range names copy absolutely.
Q16: You cannot use VLOOKUP, HLOOKUP, or LOOKUP
Q18: Headings at the top of each column
Q19: A table_array argument must contain relative cell
Q20: You can use a VLOOKUP formula and
Q21: VLOOKUP searches for a matching value in
Q22: The data you are looking up is
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