DATABASE FUNDAMENTALS
USING THE UPPER AND LOWER FUNCTIONS IN EXCEL
|
Question
[CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
|
|
|
Search
|
|
|
HLOOKUP
|
|
|
Max
|
|
|
Count
|
|
|
VLOOKUP
|
Detailed explanation-1: -VLOOKUP allows you to search a data range that is set up vertically. HLOOKUP is the exact same function, but looks up data that has been formatted by rows instead of columns. LOOKUP and related functions are commonly used for business analytics in Excel as a way of slicing and dicing data for analysis.
Detailed explanation-2: -Look up vertically and horizontally Microsoft Excel used to have two functions for different lookup types, each having its own syntax and usage rules: VLOOKUP to look vertically in a column and HLOOKUP to look horizontally in a row. The XLOOKUP function can do both with the same syntax.
Detailed explanation-3: -Use VLOOKUP when you need to find things in a table or a range by row. For example, look up a price of an automotive part by the part number, or find an employee name based on their employee ID.
Detailed explanation-4: -Because the range lookup value was omitted, VLOOKUP uses an approximate match, which requires the data to be sorted in ascending order.