Homework Help is Here – Start Your Trial Now!
Engineering
Computer Engineering
INDEX function to search for data in a sorted list

INDEX function to search for data in a sorted list

Computer Networking: A Top-Down Approach (7th Edition)
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...
See similar textbooks
icon
Related questions
Question
How the Use of the INDEX function to search for data in a sorted list, be useful and applicable in business and other transactions?
Use the INDEX function to search for data in a sorted list In addition to VLOOKUP, the INDEX function can be used to search for data in a sorted list. Copy the table below to a new worksheet and enter in cell A2 the team number for which you want to search. Let Excel search for the team name and corresponding costs with the INDEX or VLOOKUP functions as described in the next steps. • To search for data in a list: 1. In cells A2 and A3, enter valid numbers between 1 and 7. 2. cell B2 and type the following formula: =INDEX($A$6:$C$12,MATCH($A$2,$A$6:$A$12,0),2). Lookup and Reference Functions • 263 3. In cell B3, type the following formula: =VLOOKUP($A$3,$A$5: $C$12,2,FALSE). 4. Select cell C2 and type the following formula: =INDEX($A$6:$C$12,MATCH($A$2,$A$6:$A$12,0),3). 5. In cell C3, type the following formula: =VLOOKUP($A$3,$A$5:$C$12, 3,FALSE). 6. Press <Enter>. Chapter 9atar - Excel Sign in o File Home Insert Page Layout Inquire Power Pivot O Tell me 8 Formulas Data Review View C3 VLOOKUP(SA$3,SA$5:$C$12,3,FALSE) A E 1 No. 3 team 3 Team Cost $ 5,360 $ 2,291 2 3 4 team 4 4 No. Team Cost 1 $ 2,434 $ 7,818 $ 5,360 $ 2,291 $ 8,205 $ 4,989 $ 3,721 6 team 1 team 2 team 3 9 4 team 10 team 5 11 6 team 6 12 team 7 13 14 15 16 17 18 search data in sorted list battleship Ready + 100% Figure 9-12
Transcribed Image Text:Use the INDEX function to search for data in a sorted list In addition to VLOOKUP, the INDEX function can be used to search for data in a sorted list. Copy the table below to a new worksheet and enter in cell A2 the team number for which you want to search. Let Excel search for the team name and corresponding costs with the INDEX or VLOOKUP functions as described in the next steps. • To search for data in a list: 1. In cells A2 and A3, enter valid numbers between 1 and 7. 2. cell B2 and type the following formula: =INDEX($A$6:$C$12,MATCH($A$2,$A$6:$A$12,0),2). Lookup and Reference Functions • 263 3. In cell B3, type the following formula: =VLOOKUP($A$3,$A$5: $C$12,2,FALSE). 4. Select cell C2 and type the following formula: =INDEX($A$6:$C$12,MATCH($A$2,$A$6:$A$12,0),3). 5. In cell C3, type the following formula: =VLOOKUP($A$3,$A$5:$C$12, 3,FALSE). 6. Press <Enter>. Chapter 9atar - Excel Sign in o File Home Insert Page Layout Inquire Power Pivot O Tell me 8 Formulas Data Review View C3 VLOOKUP(SA$3,SA$5:$C$12,3,FALSE) A E 1 No. 3 team 3 Team Cost $ 5,360 $ 2,291 2 3 4 team 4 4 No. Team Cost 1 $ 2,434 $ 7,818 $ 5,360 $ 2,291 $ 8,205 $ 4,989 $ 3,721 6 team 1 team 2 team 3 9 4 team 10 team 5 11 6 team 6 12 team 7 13 14 15 16 17 18 search data in sorted list battleship Ready + 100% Figure 9-12
Expert Solution
steps

Step by step

Solved in 2 steps with 1 images

SEE SOLUTIONCheck out a sample Q&A here
Blurred answer
Recommended textbooks for you
Computer Networking: A Top-Down Approach (7th Edi…
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 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)
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
Concepts of Database Management
Computer Engineering
ISBN:
9781337093422
Author:
Joy L. Starks, Philip J. Pratt, Mary Z. Last
Publisher:
Cengage Learning
Prelude to Programming
Prelude to Programming
Computer Engineering
ISBN:
9780133750423
Author:
VENIT, Stewart
Publisher:
Pearson Education
Sc Business Data Communications and Networking, T…
Sc Business Data Communications and Networking, T…
Computer Engineering
ISBN:
9781119368830
Author:
FITZGERALD
Publisher:
WILEY
SEE MORE TEXTBOOKS