DATABASE FUNDAMENTALS
HOW TO INSERT DELETE COLUMNS ROWS IN EXCEL
|
Question
[CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
|
|
|
=VLOOKUP(lookup ____ value, table ____ array, col ____ index ____ num, range ____ lookup)
|
|
|
=VLOOKUP(table ____ array, lookup ____ value, col ____ index ____ num, range ____ lookup)
|
|
|
=VLOOKUP(lookup ____ value, table ____ array, col ____ index ____ num, value)
|
|
|
=VLOOKUP(lookup ____ value, table ____ array, col ____ index ____ num, range ____ lookup, value)
|
Detailed explanation-1: -In its simplest form, the VLOOKUP function says: =VLOOKUP(What you want to look up, where you want to look for it, the column number in the range containing the value to return, return an Approximate or Exact match – indicated as 1/TRUE, or 0/FALSE).
Detailed explanation-2: -The VLOOKUP function consists of three required arguments, in the following order: lookup value, table array, and column index number. The lookup value is the value for which you want to find matching data and must appear in the first column of the lookup table; it can be a value, a text string, or a cell reference.
Detailed explanation-3: -The HLOOKUP function has the following syntax, with 3 required arguments, and 1 optional argument: HLOOKUP(lookup value, table array, row index num, [range lookup])
Detailed explanation-4: -The table array argument is always the second argument in a VLOOKUP or HLOOKUP function (the first is the value you’re trying to find), and the functions won’t work without it. Your first argument, the value you want to find, can be a specific value such as “41” or “smith, ” or it be a cell reference such as F2.