You can use a VLOOKUP formula and an HLOOKUP formula to retrieve data stored in lookup tables on the same worksheet.
Correct Answer:
Verified
Q15: Range names copy absolutely.
Q16: You cannot use VLOOKUP, HLOOKUP, or LOOKUP
Q17: When you use a lookup type of
Q18: Headings at the top of each column
Q19: A table_array argument must contain relative cell
Q21: VLOOKUP searches for a matching value in
Q22: The data you are looking up is
Q23: The Lookup function argument called lookup_vector is
Q24: In a(n) two-dimensional table, Excel can search
Q25: A data list that categorizes values you
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