USING MICROSOFT EXCEL
ADJUSTING COLUMN WIDTH ROW HEIGHT IN EXCEL
|
Question
[CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
|
The formula to finding the price using VLOOKUP is:
|
|
(LEFT (A3; 6); A11:B16; 2; FALSE)
|
|
|
(RIGHT (A3; 3); A20:D21; 2; FALSE)
|
|
|
IF (ISERROR (VLOOKUP (LEFT (A8; 6); A16:B21; 2; FALSE)); 0; ISERROR (VLOOKUP (LEFT (A8; 6); A16:B21; 2; FALSE)))
|
|
|
IFERROR (HLOOKUP (RIGHT (A8; 3); $ A $ 20:$ D $ 21; 2; FALS E); “None")
|
|
|
D3 = IF (AND (B3 = “LED TV"; C3 = “50 inch"); “Expensive"; “Medium")
|
Explanation:
Detailed explanation-1: -The VLOOKUP function only looks to the right. To look up a value in any column and return the corresponding value to the left, simply use INDEX and MATCH.
Detailed explanation-2: -What is VLOOKUP in Excel? 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-3: -This parameter determines whether you are looking for an exact match or approximate match. In this example, the fourth parameter is FALSE. 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.
There is 1 question to complete.