USING MICROSOFT EXCEL
USING THE UPPER AND LOWER FUNCTIONS IN EXCEL
|
Question
[CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
|
|
|
HLOOKUP
|
|
|
VLOOKUP
|
|
|
VLOOK
|
|
|
LOOK
|
|
|
LOOKUP
|
Detailed explanation-1: -Use HLOOKUP when your comparison values are located in a row across the top of a table of data, and you want to look down a specified number of rows. Use VLOOKUP when your comparison values are located in a column to the left of the data you want to find. The H in HLOOKUP stands for “Horizontal."
Detailed explanation-2: -HLOOKUP stands for Horizontal Lookup and can be used to retrieve information from a table by searching a row for the matching data and outputting from the corresponding column. While VLOOKUP searches for the value in a column, HLOOKUP searches for the value in a row.
Detailed explanation-3: -The VLOOKUP function can search for a specific category or value in a table and return the “opposing” value from adjacent columns. HLOOKUP works exactly in the same way except that it looks horizontally rather than vertically. “V” in VLOOKUP refers to vertical and “H” in HLOOKUP refers to horizontal.