DATABASE FUNDAMENTALS
USING THE UPPER AND LOWER FUNCTIONS IN EXCEL
|
Question
[CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
|
|
|
VLOOKUP
|
|
|
HLOOKUP
|
|
|
LOOKUP
|
|
|
SEARCH
|
Detailed explanation-1: -For example, =VLOOKUP(90, A1:B100, 2, TRUE). Exact match-0/FALSE searches for the exact value in the first column. For example, =VLOOKUP("Smith", A1:B100, 2, FALSE).
Detailed explanation-2: -When you need to find information in a large spreadsheet, or you are always looking for the same kind of information, use the VLOOKUP function. VLOOKUP works a lot like a phone book, where you start with the piece of data you know, like someone’s name, in order to find out what you don’t know, like their phone number.
Detailed explanation-3: -VLOOKUP stands for ‘Vertical Lookup’. It is a function that makes Excel search for a certain value in a column (the so called ‘table array’), in order to return a value from a different column in the same row.
Detailed explanation-4: -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. The first column of table array must contain the lookup values to search.