Spreadsheet: 163180d1340213574-using-a-formula-to-link-a-number-1-through-5-to-multiple-text-choices-book1
Sheet: Sheet1

Cities | Categories
 | Cars | Train | Boat | House | Business | Factory | Store | Church | Choice9 | Choice10 | Choice11 | Choice12 | Choice13 | Choice14 | Choice15 | Choice16 | Choice17
New York | 5 |  |  |  | 2 |  |  |  | 1 |  |  | 4 |  | 3
Chicago |  |  |  |  |  |  |  |  | 5 | 4 | 3 | 2 | 1
City 50 | 1 | 2 | 3 | 5 | 4
City 43 |  |  |  |  | 1 |  | 5 |  |  | 4 |  | 2 | 3
 | Cars | Train | Boat | House | Business | Factory | Store | Church | Choice9 | Choice10 | Choice11 | Choice12 | Choice13 | Choice14 | Choice15 | Choice16 | Choice17
Adams |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | #N/A
Chicago |  | 2 |  |  | 5 |  | 3 |  |  |  |  | 4 |  |  |  | 1 |  | 1. Choice16, 2. Train, 3. Store, 4. Choice12, 5. Business
Detroit |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | #N/A
Kirkwood |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | #N/A
New York | 1 |  | 4 | 2 |  |  |  | 3 |  |  |  |  |  |  | 5 |  |  | 1. Cars, 2. House, 3. Church, 4. Boat, 5. Choice15
[NAME] |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | #N/A
City7 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | #N/A
City8 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | #N/A
City9 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | #N/A
City10 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | #N/A
City11 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | #N/A
City12 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | #N/A
City13 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | #N/A
City14 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | #N/A
City15 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | #N/A
City16 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | #N/A
City17 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | #N/A
City18 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | #N/A
City19 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | #N/A
City20 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | #N/A
City21 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | #N/A
City22 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | #N/A
City23 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | #N/A
City24 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | #N/A
City25 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | #N/A
City26 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | #N/A
City27 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | #N/A
City28 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | #N/A
City29 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | #N/A
City30 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | #N/A
City31 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | #N/A
City32 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | #N/A
City33 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | #N/A
City34 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | #N/A
City35 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | #N/A
City36 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | #N/A
City37 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | #N/A
City38 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | #N/A
City39 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | #N/A
City40 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | #N/A
City41 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | #N/A
City42 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | #N/A
City43 |  |  | 3 |  |  | 4 |  | 5 | 2 |  |  |  |  |  |  |  | 1 | 1. Choice17, 2. Choice9, 3. Boat, 4. Factory, 5. Church
City44 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | #N/A
City45 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | #N/A
[NAME] |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | #N/A
City47 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | #N/A
City48 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | #N/A
City49 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | #N/A
City50 | 1 |  | 4 | 2 |  |  |  | 3 |  |  |  |  |  |  | 5 |  |  | 1. Cars, 2. House, 3. Church, 4. Boat, 5. Choice15
City51 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | #N/A
City52 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | #N/A
City53 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | #N/A
City54 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | #N/A
City55 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | #N/A
City56 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | #N/A
City57 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | #N/A
City58 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | #N/A
City59 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | #N/A
City60 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | #N/A
Cities