1) If the function =XLOOKUP(H13,C4:C10,B4:B10, \"Item Not Found\", 1,1) is used, what will happen if an exact match is not found?
Added by Casey K.
Close
Step 1
The syntax is: \[ \text{XLOOKUP}( \text{lookup\_value}, \text{lookup\_array}, \text{return\_array}, [\text{if\_not\_found}], [\text{match\_mode}], [\text{search\_mode}] ) \] Show more…
Show all steps
Your feedback will help us improve your experience
Tony Venetico and 91 other AP CS educators are ready to help you.
Ask a new question
Labs
Want to see this concept in action?
Explore this concept interactively to see how it behaves as you change inputs.
Key Concepts
Recommended Videos
In cell B13, create a formula using the VLOOKUP function that looks up the value from cell A11 in the range A5:B7, returns the value in column 2, and specifies an exact match.
Tony V.
In cell B13, create a formula using the VLOOKUP function that looks up the value from cell A11 in the range A5:B7, returns the value in column 2, and specifies an exact match. Copy the formula to cell E13.
Eric C.
Question 1 (4 points) Assume the "range_lookup" parameter in an HLOOKUP function is FALSE. If an exact match is not found, what value is returned? Question 1 options: #REF! An approximate match is returned Excel returns a "No value was found" error message #N/A Question 2 (4 points) What is the value to be found in the first row of the table while using the HLOOKUP function? Question 2 options: index of row table array lookup value range lookup Question 3 (4 points) What form of LOOKUP is used when you have a small list of values and the values remain constant over time? Question 3 options: static form dynamic form vector form array form Question 4 (4 points) Which of the following are TRUE in the context of using VLOOKUP? Question 4 options: You use a range or table with data in columns; the lookup_value is found in the leftmost column of the lookup table All answers provided are correct You can indicate whether the matches are approximate or exact The displayed result comes from a column number specified as a parameter Question 5 (4 points) The range_lookup parameter in VLOOKUP and HLOOKUP function is ________ Question 5 options: optional mandatory compulsory fixed Question 6 (4 points) Which of the following functions looks in a one-row or one-column range (lookup_vector) for a value (lookup_value) and returns a value from the same position in a second one-row or one-column range (result_vector). Question 6 options: LOOKUP INDEX IF MATCH Question 7 (4 points) What does it mean when Excel displays the following error? #DIV/0! Question 7 options: A number is divided by zero! A number is divided by infinity! unrecognized text none of the options provided is correct
Rachel G.
Recommended Textbooks
Computer Science and Information Technology
Introduction to Programming Using Python
Computer Science - An Overview
Transcript
Watch the video solution with this free unlock.
EMAIL
PASSWORD