DATABASE FUNDAMENTALS
HOW TO USE THE CONCATENATE FUNCTION IN EXCEL
|
Question
[CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
|
|
|
=Vlookup(key cell, table reference, column to look up, true or false)
|
|
|
=Vlookup(reference table, what column to look for, true or false, key cell)
|
|
|
=Vlookup(what column to look for, true or false, key cell)
|
|
|
=Vlookup(key cell, reference table, which column to search for, 1 or 3)
|
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: -A parameter of FALSE means that VLOOKUP is looking for an EXACT match for the value of 10251. A parameter of TRUE means that a “close” match will be returned.
Detailed explanation-3: -VLOOKUP stands for Vertical Lookup. As the name specifies, VLOOKUP is a built-in Excel function that helps you look for a specified value by searching for it vertically across the sheet.
Detailed explanation-4: -When we have a large amount of data and do not know where to look, we can select the table and name it. While using the VLOOKUP function, instead of providing the reference, we can type the table’s name as a reference to look up the value. Such a table is known as a lookup table in Excel.