| Now you are ready to use the position number as an argument within the INDEX function. In cell B4, insert an INDEX function that uses the range D8:K35, looks up the row position number from the MATCH function result, and then uses the column position number for Full Name. 
|
AutoSave OFF ESUS Home Insert Adamson_Exp19_Excel_Ch11_Cap_Donors (1) Draw Page Layout Formulas Data Review View Tell me ? A le *** Insert Function AutoSum Recently Financial Logical Used Define Name Text Date & Lookup & Math & More Time Reference Trig Functions E Trace Precedents Trace Dependents Show Error Remove Arrow Formulas Checking v B4 Calcul Create from Selection X V fx Calculation Options Calcula E G H K 2 M N Formulas Cell B3 cell 34 Cell DS Cell K2 Summary Total Donations: Average donation: Total donors. State OH OH OH IL OH OH A B C D 1 Look Up Area 2 2 Donor ID: ART-39 3 Donor Position: 6 4 Donor Name 5 Donor Amount: 6. 7 College College ID Donor ID New Donor ID 8 ENGINEERING ENG 15 ENG-15 9 BUSINESS BUS 25 BUS-25 10 BUSINESS BUS 27 BUS 27 11 ART ART 45 ART-45 12 ENGINEERING ENG 22 ENG 22 13 ART ART 39 ART-39 14 ART ART 12 ART-12 15 BUSINESS BUS 14 BUS-14 16 ENGINEERING ENG 18 ENG-18 17 ENGINEERING ENG 23 ENG-23 18 ART ART 24 ART-24 19 BUSINESS BUS 31 BUS-31 20 ART ART 36 ART 3 21 ART ART 42 ART-42 22 BUSINESS BUS 44 BUS 44 22 ART ART 30 ART 38 24 ENGINEERING ENG 52 ENG-52 25 BUSINESS BUS 53 BUS-53 26 BUSINESS BUS 49 BU5-49 27 ENGINEERING ENG 47 ENG-47 28 ENGINEERING ENG 26 ENG-26 29 ART ART 46 ART-46 30 BUSINESS BUS 55 BUS-55 31 ART ART 41 ART-41 32 ENGINEERING ENG 33 ENG-33 33 BUSINESS BUS 58 BUS-58 34 ART ART 34 ART-34 35 ENGINEERING ENG 58 ENG 58 36 37 38 139 40 41 42 43 244 Donors + Edit Full Name Schneider, Dedrick Beauclair, Oliver Fores, Adrian Wang Shan Schafer, Elysia Romero, Samantha Mikhailov, Jon Jaundreau, Hunter Kato, Eija Schroder, Genevie Diaz, Sergio Lamoureux, Lucas Acosta, Jaime Ishikawa, Chie Kruger, Alfonso Normandeau, Amelia Cabrera, Ma Fernandez, Isabella Wright, Jerri Friedrich, Ava Byram, Emma Renault, Linden Sancher, Caleb Zhang Jun Deneau, Abigail Walker, Mitchell Perez, Tina Morgan, Terry Last Name Schneider Beauclair Flores Wang Schafer Romero Mikhailov Jaundreau Kata Schroder Diaz Lamoureux Acosta Ishikawa Kruger Normandeau Cabrera Fernandez Wright Friedrich Byram Renault Sanchez Address 1243 W Abbey Rd 34 E Affinity Dr 912 Elullen Circle 2945 N Country Club Rd 259 S Wadsbury Dr 123 W Lincoln Ave 342 S Newton Dr 64 E 111th Place 41 W Eaton Drive 6124 N Odelle Dr 142 5 Elm Street 3415 N Saddlewood Dr 1490 S Alcove Way 4152 E Dalbren in 641 W Banbury Dr 45 E Blackstone Court 923 W Haldy Rd 641 S Caiser Court 64 W Garden Court 15 E Oak Hill Drive 324 E Deer Valley Drive 3434 E Wallhaven Circle 25 W Catherine Street 3914 McCartney Rd 345 N Cobb Place 1850 N Lelanford Cir 45 E Keyes Ave 1200 E. Monticello Blvd City Columbus Cincinnati Akron Chicago Heights Cincinnati Dayton Columbus Chicago Toledo Akron Erle Toledo Pittsburgh Cincinnati Toledo Detroit Columbus San Francisco Bowling Green Anaheim Park City Akron Ann Arbor Youngstown Detroit Bowling Green Cleveland Cleveland OH IL OH OH PA OH PA OH College/School Engineering Business Business Art Engineering Art Art Business Engineering Engineering Art Business Art Art Business Art Engineering Business Business Engineering Engneering Art Business Art Engineering Business Art Engineering Donation 5,000 7,500 10,000 3,500 4,000 6,000 750 500 1,250 3.000 1,255 3,000 855 6.500 2,500 5,555 3,545 4,210 900 950 11,000 12.500 2.355 900 1,600 655 6,545 750 MI OH CA OH CA UT OH MI OH MI OH OH OH R Zhang sta Deneau Walker Perez Morgan Sy LER - TO ya . Nu war ID esc OOO CACC 1 1 2 3 $ 4 % 5 6 & 7 00 Q 9 W E R T Y U A S D F C
