Changing Lists

Make initial selection 2

Index of selection

A B C D E F G H I J K L

A1 B1 C1 D1 E1 F1 G1 H1 I1 J1 K1 L1

A2 B2 C2 D2 E2 F2 G2 H2 I2 J2 K2 L2

A3 B3 C3 D3 E3 F3 G3 H3 I3 J3 K3 L3

A4 B4 C4 D4 E4 F4 G4 H4 I4 J4 K4 L4

4 B1 B2 B3 B4 B5 B6 B7 B8

Data used for first selection

Make secondary selection Data used for second selection

A5 B5 C5 D5 E5 F5 G5 H5 I5 J5 K5 L5

A6 B6 C6 D6 E6 F6 G6 H6 I6 J6 K6 L6

Data used for first selection

d for second selection

A7 B7 C7 D7 E7 F7 G7 H7 I7 J7 K7 L7

A8 B8 C8 D8 E8 F8 G8 H8 I8 J8 K8 L8

Make initial selection A A1 B B1 C C1 D D1 E E1 K4 F F1 G G1 H H1 I I1 J J1 K K1 L L1 Make secondary selection K

A2 B2 C2 D2 E2 F2 G2 H2 I2 J2 K2 L2

A3 B3 C3 D3 E3 F3 G3 H3 I3 J3 K3 L3

Data used

A4 B4 C4 D4 E4 F4 G4 H4 I4 J4 K4 L4

A5 B5 C5 D5 E5 F5 G5 H5 I5 J5 K5 L5

A6 B6 C6 D6 E6 F6 G6 H6 I6 J6 K6 L6

A7 B7 C7 D7 E7 F7 G7 H7 I7 J7 K7 L7

A8 B8 C8 D8 E8 F8 G8 H8 I8 J8 K8 L8

Widget1 Sub Item 36

Select Sub Item

Select Widget Type 4444458

Item Number

Widget1 Sub Item 2

4444450

Team Sub Item 1 Sub Item 2 Sub Item 3 Sub Item 4 Sub Item 5 Sub Item 6 Sub Item 7 Sub Item 8 Sub Item 9 Sub Item 10 Sub Item 11 Sub Item 12 Sub Item 13 Sub Item 14 Sub Item 15 Sub Item 16 Sub Item 17 Sub Item 18 Sub Item 19 Sub Item 20 Sub Item 21 Sub Item 22 Sub Item 23 Sub Item 24 Sub Item 25 Sub Item 26 Sub Item 27 Sub Item 28 Sub Item 29 Sub Item 30 Sub Item 31 Sub Item 32 Sub Item 33 Sub Item 34 Sub Item 35 Sub Item 36 Sub Item 37 Sub Item 38 Sub Item 39 Sub Item 40 Sub Item 41 Sub Item 42 Sub Item 43 Sub Item 44 Sub Item 45 Sub Item 46 Sub Item 47

Sku 5555551 5555552 5555553 5555554 5555555 5555556 5555557 5555558 5555559 5555560 5555561 5555562 5555563 5555564 5555565 5555566 5555567 5555568 5555569 5555570 5555571 5555572 5555573 5555574 5555575 5555576 5555577 5555578 5555579 5555580 5555581 5555582 5555583 5555584 5555585 5555586 5555587 5555588 5555589 5555590 5555591 5555592 5555593 5555594 5555595 5555596 5555597

Description Widget 1 Widget 1 Widget 1 Widget 1 Widget 1 Widget 1 Widget 1 Widget 1 Widget 1 Widget 1 Widget 1 Widget 1 Widget 1 Widget 1 Widget 1 Widget 1 Widget 1 Widget 1 Widget 1 Widget 1 Widget 1 Widget 1 Widget 1 Widget 1 Widget 1 Widget 1 Widget 1 Widget 1 Widget 1 Widget 1 Widget 1 Widget 1 Widget 1 Widget 1 Widget 1 Widget 1 Widget 1 Widget 1 Widget 1 Widget 1 Widget 1 Widget 1 Widget 1 Widget 1 Widget 1 Widget 1 Widget 1

Sub Item 48 Sub Item 49 Sub Item 50 Sub Item 51 Sub Item 52 Sub Item 53 Sub Item 54 Sub Item 55 Sub Item 56 Sub Item 57 Sub Item 58 Sub Item 59 Sub Item 60 Sub Item 61 Sub Item 62 Sub Item 63 Sub Item 64 Sub Item 65 Sub Item 66 Sub Item 67 Sub Item 68 Sub Item 69 Sub Item 70 Sub Item 71 Sub Item 72 Sub Item 73 Sub Item 74 Sub Item 75 Sub Item 76 Sub Item 77 Sub Item 78 Sub Item 79 Sub Item 80 Sub Item 81 Sub Item 82 Sub Item 83 Sub Item 84 Sub Item 85 Sub Item 86 Sub Item 87 Sub Item 88 Sub Item 89 Sub Item 90 Sub Item 91 Sub Item 92 Sub Item 93 Sub Item 94 Sub Item 95 Sub Item 96 Sub Item 97 Sub Item 98 Sub Item 99

5555598 5555599 5555600 5555601 5555602 5555603 5555604 5555605 5555606 5555607 5555608 5555609 5555610 5555611 5555612 5555613 5555614 5555615 5555616 5555617 5555618 5555619 5555620 5555621 5555622 5555623 5555624 5555625 5555626 5555627 5555628 5555629 5555630 5555631 5555632 5555633 5555634 5555635 5555636 5555637 5555638 5555639 5555640 5555641 5555642 5555643 5555644 5555645 5555646 5555647 5555648 5555649

Widget 1 Widget 1 Widget 1 Widget 1 Widget 1 Widget 1 Widget 1 Widget 1 Widget 1 Widget 1 Widget 1 Widget 1 Widget 1 Widget 1 Widget 1 Widget 1 Widget 1 Widget 1 Widget 1 Widget 1 Widget 1 Widget 1 Widget 1 Widget 1 Widget 1 Widget 1 Widget 1 Widget 1 Widget 1 Widget 1 Widget 1 Widget 1 Widget 1 Widget 1 Widget 1 Widget 1 Widget 1 Widget 1 Widget 1 Widget 1 Widget 1 Widget 1 Widget 1 Widget 1 Widget 1 Widget 1 Widget 1 Widget 1 Widget 1 Widget 1 Widget 1 Widget 1

Sub Item 100 Sub Item 101 Sub Item 102 Sub Item 103 Sub Item 104 Sub Item 105 Sub Item 106 Sub Item 107 Sub Item 108 Sub Item 109 Sub Item 110 Sub Item 111 Sub Item 112 Sub Item 113 Sub Item 114 Sub Item 115 Sub Item 116 Sub Item 117 Sub Item 118 Sub Item 119 Sub Item 120 Sub Item 121 Sub Item 122 Sub Item 123 Sub Item 124 Sub Item 125 Sub Item 126 Sub Item 127 Sub Item 128 Sub Item 129 Sub Item 130 Sub Item 131 Sub Item 132 Sub Item 133 Sub Item 134 Sub Item 135 Sub Item 136 Sub Item 137 Sub Item 138 Sub Item 139 Sub Item 140 Sub Item 141 Sub Item 142 Sub Item 143 Sub Item 144 Sub Item 145 Sub Item 146 Sub Item 147 Sub Item 148 Sub Item 149 Sub Item 150 Sub Item 151

5555650 5555651 5555652 5555653 5555654 5555655 5555656 5555657 5555658 5555659 5555660 5555661 5555662 5555663 5555664 5555665 5555666 5555667 5555668 5555669 5555670 5555671 5555672 5555673 5555674 5555675 5555676 5555677 5555678 5555679 5555680 5555681 5555682 5555683 5555684 5555685 5555686 5555687 5555688 5555689 5555690 5555691 5555692 5555693 5555694 5555695 5555696 5555697 5555698 5555699 5555700 5555701

Widget 1 Widget 1 Widget 1 Widget 1 Widget 1 Widget 1 Widget 1 Widget 1 Widget 1 Widget 1 Widget 1 Widget 1 Widget 1 Widget 1 Widget 1 Widget 1 Widget 1 Widget 1 Widget 1 Widget 1 Widget 1 Widget 1 Widget 1 Widget 1 Widget 1 Widget 1 Widget 1 Widget 1 Widget 1 Widget 1 Widget 1 Widget 1 Widget 1 Widget 1 Widget 1 Widget 1 Widget 1 Widget 1 Widget 1 Widget 1 Widget 1 Widget 1 Widget 1 Widget 1 Widget 1 Widget 1 Widget 1 Widget 1 Widget 1 Widget 1 Widget 1 Widget 1

Sub Item 152 Sub Item 153 Sub Item 154 Sub Item 155 Sub Item 156 Sub Item 157 Sub Item 158 Sub Item 159 Sub Item 160 Sub Item 161 Sub Item 162 Sub Item 163 Sub Item 164 Sub Item 165 Sub Item 166

5555702 5555703 5555704 5555705 5555706 5555707 5555708 5555709 5555710 5555711 5555712 5555713 5555714 5555715 5555716

Widget 1 Widget 1 Widget 1 Widget 1 Widget 1 Widget 1 Widget 1 Widget 1 Widget 1 Widget 1 Widget 1 Widget 1 Widget 1 Widget 1 Widget 1

Team Sub Item 1 Sub Item 3 Sub Item 7 Sub Item 8 Sub Item 9 Sub Item 11 Sub Item 16 Sub Item 20 Sub Item 24 Sub Item 2 Sub Item 25 Sub Item 26 Sub Item 27 Sub Item 29 Sub Item 31 Sub Item 33 Sub Item 34 Sub Item 36 Sub Item 38 Sub Item 41 Sub Item 44 Sub Item 45 Sub Item 46 Sub Item 47 Sub Item 48 Sub Item 49 Sub Item 50 Sub Item 51 Sub Item 52 Sub Item 53 Sub Item 54 Sub Item 55 Sub Item 56 Sub Item 57 Sub Item 58 Sub Item 59 Sub Item 60 Sub Item 61 Sub Item 62 Sub Item 63 Sub Item 64 Sub Item 65 Sub Item 66 Sub Item 67 Sub Item 68 Sub Item 69 Sub Item 70

Sku 4444441 4444442 4444443 4444444 4444445 4444446 4444447 4444448 4444449 4444450 4444451 4444452 4444453 4444454 4444455 4444456 4444457 4444458 4444459 4444460 4444461 4444462 4444463 4444464 4444465 4444466 4444467 4444468 4444469 4444470 4444471 4444472 4444473 4444474 4444475 4444476 4444477 4444478 4444479 4444480 4444481 4444482 4444483 4444484 4444485 4444486 4444487

Description Widget 2 Widget 2 Widget 2 Widget 2 Widget 2 Widget 2 Widget 2 Widget 2 Widget 2 Widget 2 Widget 2 Widget 2 Widget 2 Widget 2 Widget 2 Widget 2 Widget 2 Widget 2 Widget 2 Widget 2 Widget 2 Widget 2 Widget 2 Widget 2 Widget 2 Widget 2 Widget 2 Widget 2 Widget 2 Widget 2 Widget 2 Widget 2 Widget 2 Widget 2 Widget 2 Widget 2 Widget 2 Widget 2 Widget 2 Widget 2 Widget 2 Widget 2 Widget 2 Widget 2 Widget 2 Widget 2 Widget 2

Widget1 Widget2

Sub Item 71 Sub Item 72 Sub Item 73 Sub Item 74 Sub Item 76 Sub Item 78 Sub Item 79 Sub Item 80 Sub Item 81 Sub Item 82 Sub Item 83 Sub Item 84 Sub Item 85 Sub Item 87 Sub Item 89 Sub Item 90 Sub Item 91 Sub Item 92 Sub Item 94 Sub Item 95 Sub Item 96 Sub Item 97 Sub Item 98 Sub Item 99 Sub Item 100 Sub Item 101 Sub Item 102 Sub Item 103 Sub Item 105 Sub Item 106 Sub Item 107 Sub Item 108 Sub Item 109 Sub Item 110 Sub Item 111 Sub Item 112 Sub Item 113 Sub Item 114 Sub Item 115 Sub Item 116 Sub Item 117 Sub Item 118 Sub Item 119 Sub Item 120 Sub Item 121 Sub Item 122 Sub Item 123 Sub Item 124 Sub Item 125 Sub Item 126 Sub Item 127 Sub Item 128

4444488 4444489 4444490 4444491 4444492 4444493 4444494 4444495 4444496 4444497 4444498 4444499 4444500 4444501 4444502 4444503 4444504 4444505 4444506 4444507 4444508 4444509 4444510 4444511 4444512 4444513 4444514 4444515 4444516 4444517 4444518 4444519 4444520 4444521 4444522 4444523 4444524 4444525 4444526 4444527 4444528 4444529 4444530 4444531 4444532 4444533 4444534 4444535 4444536 4444537 4444538 4444539

Widget 2 Widget 2 Widget 2 Widget 2 Widget 2 Widget 2 Widget 2 Widget 2 Widget 2 Widget 2 Widget 2 Widget 2 Widget 2 Widget 2 Widget 2 Widget 2 Widget 2 Widget 2 Widget 2 Widget 2 Widget 2 Widget 2 Widget 2 Widget 2 Widget 2 Widget 2 Widget 2 Widget 2 Widget 2 Widget 2 Widget 2 Widget 2 Widget 2 Widget 2 Widget 2 Widget 2 Widget 2 Widget 2 Widget 2 Widget 2 Widget 2 Widget 2 Widget 2 Widget 2 Widget 2 Widget 2 Widget 2 Widget 2 Widget 2 Widget 2 Widget 2 Widget 2

Sub Item 129 Sub Item 130 Sub Item 131 Sub Item 132 Sub Item 133 Sub Item 134 Sub Item 135 Sub Item 136 Sub Item 137 Sub Item 139 Sub Item 140 Sub Item 142 Sub Item 143 Sub Item 144 Sub Item 146 Sub Item 147 Sub Item 150 Sub Item 151 Sub Item 152 Sub Item 154 Sub Item 155 Sub Item 156 Sub Item 158 Sub Item 159 Sub Item 160 Sub Item 161 Sub Item 162 Sub Item 164 Sub Item 166 Sub Item 167 Sub Item 168 Sub Item 169 Sub Item 170 Sub Item 171

4444540 4444541 4444542 4444543 4444544 4444545 4444546 4444547 4444548 4444549 4444550 4444551 4444552 4444553 4444554 4444555 4444556 4444557 4444558 4444559 4444560 4444561 4444562 4444563 4444564 4444565 4444566 4444567 4444568 4444569 4444570 4444571 4444572 4444573

Widget 2 Widget 2 Widget 2 Widget 2 Widget 2 Widget 2 Widget 2 Widget 2 Widget 2 Widget 2 Widget 2 Widget 2 Widget 2 Widget 2 Widget 2 Widget 2 Widget 2 Widget 2 Widget 2 Widget 2 Widget 2 Widget 2 Widget 2 Widget 2 Widget 2 Widget 2 Widget 2 Widget 2 Widget 2 Widget 2 Widget 2 Widget 2 Widget 2 Widget 2

5

400 Formula can be incorporated into other formulas

This one uses a combobox from Drawing toolbar Input Range is G1:G7 Linked cell is A1, hidden beneath combobox.

A B C D E F G

1 2 4 8 16 32 64

E

16 Formula can be incorporated into other formulas

This one uses Data Validation (Data|Validation from menu) Using list in Validation criteria Source is G1:G7

A B C D E F G

1 2 4 8 16 32 64