Use the LOOKUP function to get the directory of a store A store sells different products in a big warehouse. Each floor contains different categories of products. For example, the customer can find soft- ware on the first floor and hardware on the second floor. Each category is assigned a combination of two letters, such as software = SO, hardware = HA, food = FO, indoor = IN, and outdoor = OU. The task now is to find which 260 • Microsoft Excel Functions and Formulas, Fifth Edition products are sold on which floor by entering the category abbreviation in cell A9. Do this by using the array form of the LOOKUP function to return a value from a one-row or one-column range or from an array. LOOKUP(lookup_value, array) lookup_value: A value that will be looked up in an array. array: A range of cells containing text, numbers, or logical values that are to be compared with lookup_value. > To display the correct floor: 1. In a worksheet, copy cells Al:C6, as shown in Figure 9–10. 2. In cell A9, enter the abbreviation of the product category.
Use the LOOKUP function to get the directory of a store A store sells different products in a big warehouse. Each floor contains different categories of products. For example, the customer can find soft- ware on the first floor and hardware on the second floor. Each category is assigned a combination of two letters, such as software = SO, hardware = HA, food = FO, indoor = IN, and outdoor = OU. The task now is to find which 260 • Microsoft Excel Functions and Formulas, Fifth Edition products are sold on which floor by entering the category abbreviation in cell A9. Do this by using the array form of the LOOKUP function to return a value from a one-row or one-column range or from an array. LOOKUP(lookup_value, array) lookup_value: A value that will be looked up in an array. array: A range of cells containing text, numbers, or logical values that are to be compared with lookup_value. > To display the correct floor: 1. In a worksheet, copy cells Al:C6, as shown in Figure 9–10. 2. In cell A9, enter the abbreviation of the product category.
Computer Networking: A Top-Down Approach (7th Edition)
7th Edition
ISBN:9780133594140
Author:James Kurose, Keith Ross
Publisher:James Kurose, Keith Ross
Chapter1: Computer Networks And The Internet
Section: Chapter Questions
Problem R1RQ: What is the difference between a host and an end system? List several different types of end...
Related questions
Question
How does the Use of LOOKUP function to get the directory of a
store, be useful and applicable in business and other transactions?
Transcribed Image Text:Use the LOOKUP function to get the directory of a
store
A store sells different products in a big warehouse. Each floor contains
different categories of products. For example, the customer can find soft-
ware on the first floor and hardware on the second floor. Each category is
assigned a combination of two letters, such as software = SO, hardware = HA,
food = FO, indoor = IN, and outdoor = OU. The task now is to find which
260 • Microsoft Excel Functions and Formulas, Fifth Edition
products are sold on which floor by entering the category abbreviation in
cell A9. Do this by using the array form of the LOOKUP function to return
a value from a one-row or one-column range or from an array.
LOOKUP(lookup_value, array)
lookup_value: A value that will be looked up in an array.
array: A range of cells containing text, numbers, or logical values that are to
be compared with lookup_value.
• To display the correct floor:
1. In a worksheet, copy cells Al:C6, as shown in Figure 9–10.
2. In cell A9, enter the abbreviation of the product category.
Chapter 9alsx - Excel
Sign in
File Home Insert Page Layout Formulas Data Review
Inquire Power Pivot
O Tell me &
View
C9
=LOOKUP(SA$9,SA$1:SC$8)
A
D
G
K
Code
Category Floor
software
1
2
SO
1
3
НА
hardware
4
FO
food
4
5
IN
indoor
3
6
OU
outdoor
FO
food
4
10
11
12
13
14
15
16
17
18
store directory
indicator for temperature .. O
Ready
+ 100%
Figure 9-10
NOTE: The array form of the LOOKUP function is provided for compatibility with
other spreadsheet programs. VLOOKUP can also be used in this situation, provided
that the values in the first column are sorted in ascending order.
Expert Solution
This question has been solved!
Explore an expertly crafted, step-by-step solution for a thorough understanding of key concepts.
Step by step
Solved in 2 steps
Recommended textbooks for you
Computer Networking: A Top-Down Approach (7th Edi…
Computer Engineering
ISBN:
9780133594140
Author:
James Kurose, Keith Ross
Publisher:
PEARSON
Computer Organization and Design MIPS Edition, Fi…
Computer Engineering
ISBN:
9780124077263
Author:
David A. Patterson, John L. Hennessy
Publisher:
Elsevier Science
Network+ Guide to Networks (MindTap Course List)
Computer Engineering
ISBN:
9781337569330
Author:
Jill West, Tamara Dean, Jean Andrews
Publisher:
Cengage Learning
Computer Networking: A Top-Down Approach (7th Edi…
Computer Engineering
ISBN:
9780133594140
Author:
James Kurose, Keith Ross
Publisher:
PEARSON
Computer Organization and Design MIPS Edition, Fi…
Computer Engineering
ISBN:
9780124077263
Author:
David A. Patterson, John L. Hennessy
Publisher:
Elsevier Science
Network+ Guide to Networks (MindTap Course List)
Computer Engineering
ISBN:
9781337569330
Author:
Jill West, Tamara Dean, Jean Andrews
Publisher:
Cengage Learning
Concepts of Database Management
Computer Engineering
ISBN:
9781337093422
Author:
Joy L. Starks, Philip J. Pratt, Mary Z. Last
Publisher:
Cengage Learning
Prelude to Programming
Computer Engineering
ISBN:
9780133750423
Author:
VENIT, Stewart
Publisher:
Pearson Education
Sc Business Data Communications and Networking, T…
Computer Engineering
ISBN:
9781119368830
Author:
FITZGERALD
Publisher:
WILEY