USING MICROSOFT EXCEL
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: -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-2: -The VLOOKUP or Vertical Lookup function is used when data is listed in columns. This function searches for a value in the left-most column and matches it with data in a specified column in the same row. You can use VLOOKUP to find data in a sorted or unsorted table.
Detailed explanation-3: -Using a combination INDEX and MATCH, we can find a matching value when the lookup value is not on the first column of the table array. INDEX() returns the value of a cell in a table based on the column and row number. MATCH() returns the position of a cell in a row or column.
Detailed explanation-4: -Formula 1. It is important that the helper column should be the leftmost column in the table array because it’s where Excel VLOOKUP always searches for the lookup value.