Question: In XLookup, the second argument includes ____________ whereas the third arguement includes _____________. A. The cell range that you want Excel to search in to
In XLookup, the second argument includes ____________ whereas the third arguement includes _____________.
| A. | The cell range that you want Excel to search in to find (match) the value of the cell entered in the first arguement; the cell range containing the corresponding value you want Excel to return. | |
| B. | The cell range that you want Excel to search in to find (match) the value of the cell entered in the first arguement; the column number that contains the values that you want Excel to return | |
| C. | The cell containing the value you want Excel to search for; The cell range that you want Excel to search in to find (match) the value of the cell entered in the first arguement. | |
| D. | The cell range containing the corresponding value you want Excel to return; the cell range that you want Excel to search in to find (match) the value of the cell entered in the first arguement. |
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
