USING MICROSOFT EXCEL
HOW TO ADD COPY AND MOVE WORKSHEETS WITHIN EXCEL WORKBOOKS
|
Question
[CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
|
|
|
range containing data
|
|
|
Price of the item being looked for
|
|
|
Either A or B
|
|
|
None of the above
|
Detailed explanation-1: -Arguments. VLOOKUP takes four arguments: lookup value, table array, column index num, and range lookup. Lookup value is the value to look for, and table array is the range of vertical data to look inside.
Detailed explanation-2: -The VLOOKUP function has the following syntax for its four arguments: VLOOKUP(lookup value, table array, col index num, [range lookup])
Detailed explanation-3: -There are four pieces of information that you will need in order to build the VLOOKUP syntax: The value you want to look up, also called the lookup value. The range where the lookup value is located. Remember that the lookup value should always be in the first column in the range for VLOOKUP to work correctly.
Detailed explanation-4: -VLOOKUP Formula Lookup value (required argument) – Lookup value specifies the value that we want to look up in the first column of a table. Table array (required argument) – The table array is the data array that is to be searched. The VLOOKUP function searches in the left-most column of this array.