Spreadsheet: 450536d1457736245-new-to-index-index-formula-not-working-indexnameandaddress
Sheet: SelectName

Record No | Key Code | Last | First | Full Name | Address One | Address Two | Address Three | Post Code | [NAME] | Telephone | Mobile |  |  |  |  |  |  | <----------------------------------------------------------------------------------------------------------------------EXTRACT TABLE------------------------------------------------------------------------------------------------------------>
1 | Millhouse1 | Millhouse | Roselyn | [NAME] | 718 Shropshire Boulevard | Los Angeles | California | CA 90781 | [EMAIL] | +[PHONE] | [PHONE] |  |  | Search for |  |  | [NAME] | Record No | Last | First | Full Name | Address One | Address Two | Address Three | Post Code | [NAME] | Telephone | Mobile
2 | Smith2 | Smith | [NAME] | [NAME] | 1705 Shropshire Boulevard | Los Angeles | California | CA 90607 | [EMAIL] | +[PHONE] | [PHONE] |  |  | (Last Name):
3 | Sagucio3 | [NAME] | [NAME] | [NAME] | 605 Shropshire Boulevard | Los Angeles | California | CA 90801 | [EMAIL] | +[PHONE] | [PHONE] |  |  |  |  |  | Smith2 | 2 | Smith | [NAME] | [NAME] | 1705 Shropshire Boulevard | Los Angeles | California | CA 90607 | [EMAIL] | +[PHONE] | [PHONE]
4 | Wingfield4 | Wingfield | [NAME] | [NAME] | 630 Shropshire Boulevard | Los Angeles | California | CA 90685 | [EMAIL] | +[PHONE] | [PHONE] |  |  | Smith |  |  | Smith7 | 7 | Smith | [NAME] | [NAME] | 710 Shropshire Boulevard | Los Angeles | California | CA 90605 | [EMAIL] | +[PHONE] | [PHONE]
5 | Fullen5 | Fullen | Tereasa | [NAME] | 1057 Shropshire Boulevard | Los Angeles | California | CA 90793 | [EMAIL] | +[PHONE] | [PHONE]
6 | Tremblay6 | Tremblay | Tami | [NAME] | 1615 Shropshire Boulevard | Los Angeles | California | CA 90664 | [EMAIL] | +[PHONE] | [PHONE] |  | Note: Type name+Rec No in Cell N5
7 | Smith7 | Smith | [NAME] | [NAME] | 710 Shropshire Boulevard | Los Angeles | California | CA 90605 | [EMAIL] | +[PHONE] | [PHONE] |  | At present it matches all
8 | Hopewell8 | [NAME] | [NAME] | [NAME] | 1431 Shropshire Boulevard | Los Angeles | California | CA 90645 | [EMAIL] | +[PHONE] | [PHONE] |  | those starting with '[NAME]' (2 No)
9 | Dombroski9 | Dombroski | Ricardo | [NAME] | 197 Shropshire Boulevard | Los Angeles | California | CA 90809 | [EMAIL] | +[PHONE] | [NAME] |  | To eliminate duplicates, append
10 | Alvarez10 | [NAME] | [NAME] | [NAME] | 1018 Shropshire Boulevard | Los Angeles | California | CA 90694 | [EMAIL] | +[PHONE] | [PHONE] |  | the Rec No as shown in record key.
11 | Mastrangelo11 | [NAME] | Mandi | [NAME] | 800 Shropshire Boulevard | Los Angeles | California | CA 90792 | [EMAIL] | +[PHONE] | [PHONE]
12 | Theberge12 | Theberge | Alden | Alden Theberge | 1627 Shropshire Boulevard | Los Angeles | California | CA 90658 | [EMAIL] | +[PHONE] | [PHONE]
13 | Tatom13 | Tatom | [NAME] | [NAME] | 1098 Shropshire Boulevard | Los Angeles | California | CA 90656 | [EMAIL] | +[PHONE] | [PHONE]
14 | Sedor14 | Sedor | Hermine | Hermine Sedor | 653 Shropshire Boulevard | Los Angeles | California | CA 90732 | [EMAIL] | +[PHONE] | [PHONE]
15 | Motta15 | Motta | Maye | [NAME] | 180 Shropshire Boulevard | Los Angeles | California | CA 90723 | [EMAIL] | +[PHONE] | [PHONE]
16 | Gleason16 | [NAME] | Clemmie | [NAME] | 1416 Shropshire Boulevard | Los Angeles | California | CA 90693 | [EMAIL] | +[PHONE] | [PHONE]
17 | Bowden17 | Bowden | Julie | [NAME] | 979 Shropshire Boulevard | Los Angeles | California | CA 90732 | [EMAIL] | +[PHONE] | [PHONE]
18 | Kita18 | [NAME] | [NAME] | [NAME] | 1314 Shropshire Boulevard | Los Angeles | California | CA 90608 | [EMAIL] | +[PHONE] | [PHONE]
19 | Greenspan19 | [NAME] | Sharie | [NAME] | 907 Shropshire Boulevard | Los Angeles | California | CA 90601 | [EMAIL] | +[PHONE] | [PHONE]
20 | Hinson20 | Hinson | Lidia | Lidia Hinson | 1272 Shropshire Boulevard | Los Angeles | California | CA 90683 | [EMAIL] | +[PHONE] | [PHONE]
21 | Kirwan21 | Kirwan | [NAME] | [NAME] | 1592 Shropshire Boulevard | Los Angeles | California | CA 90807 | [EMAIL] | +[PHONE] | [PHONE]
22 | Aleman22 | Aleman | Mable | Mable Aleman | 1273 Shropshire Boulevard | Los Angeles | California | CA 90793 | [EMAIL] | +[PHONE] | [PHONE]
23 | Steinhauser23 | Steinhauser | Deedra | [NAME] | 250 Shropshire Boulevard | Los Angeles | California | CA 90664 | [EMAIL] | +[PHONE] | [PHONE]
24 | Deland24 | Deland | [NAME] | [NAME] | 241 Shropshire Boulevard | Los Angeles | California | CA 90625 | [EMAIL] | +[PHONE] | [PHONE]
25 | Mcferrin25 | Mcferrin | Carlota | Carlota Mcferrin | 1440 Shropshire Boulevard | Los Angeles | California | CA 90723 | [EMAIL] | +[PHONE] | [PHONE]
26 | Ronald26 | [NAME] | [NAME] | [NAME] | 655 Shropshire Boulevard | Los Angeles | California | CA 90774 | [EMAIL] | +[PHONE] | [PHONE]
27 | Stein27 | [NAME] | Abbey | [NAME] | 830 Shropshire Boulevard | Los Angeles | California | CA 90714 | [EMAIL] | +[PHONE] | [PHONE]
28 | Solorzano28 | Solorzano | Krystina | [NAME] | 459 Shropshire Boulevard | Los Angeles | California | CA 90739 | [EMAIL] | +[PHONE] | [PHONE]
29 | Gladding29 | Gladding | Belinda | [NAME] | 1408 Shropshire Boulevard | Los Angeles | California | CA 90673 | [EMAIL] | +[PHONE] | [PHONE]
30 | Hendershott30 | [NAME] | Eleanore | [NAME] | 967 Shropshire Boulevard | Los Angeles | California | CA 90712 | [EMAIL] | +[PHONE] | [PHONE]
31 | Ciriaco31 | Ciriaco | Alicia | [NAME] | 261 Shropshire Boulevard | Los Angeles | California | CA 90771 | [EMAIL] | +[PHONE] | [PHONE]
32 | Bergan32 | [NAME] | [NAME] | [NAME] | 955 Shropshire Boulevard | Los Angeles | California | CA 90783 | [EMAIL] | +[PHONE] | [PHONE]
33 | Rappa33 | Rappa | Soo | Soo Rappa | 1626 Shropshire Boulevard | Los Angeles | California | CA 90760 | [EMAIL] | +[PHONE] | [PHONE]
34 | Hennig34 | Hennig | Granville | [NAME] | 890 Shropshire Boulevard | Los Angeles | California | CA 90798 | [EMAIL] | +[PHONE] | [PHONE]
35 | Wooton35 | Wooton | Beverlee | [NAME] | 323 Shropshire Boulevard | Los Angeles | California | [NAME] | [EMAIL] | +[PHONE] | [PHONE]
36 | Lore36 | Lore | [NAME] | [NAME] | 1502 Shropshire Boulevard | Los Angeles | California | CA 90825 | [EMAIL] | +[PHONE] | [PHONE]
37 | Joyal37 | Joyal | Alona | Alona Joyal | 1338 Shropshire Boulevard | Los Angeles | California | CA 90820 | [EMAIL] | +[PHONE] | [PHONE]
38 | Derossett38 | Derossett | Ewa | [NAME] | 1549 Shropshire Boulevard | Los Angeles | California | CA 90773 | [EMAIL] | +[PHONE] | [PHONE]
39 | Kuhl39 | Kuhl | [NAME] | [NAME] | 1004 Shropshire Boulevard | Los Angeles | California | CA 90737 | [EMAIL] | +[PHONE] | [PHONE]
40 | Spady40 | Spady | Jena | [NAME] | 319 Shropshire Boulevard | Los Angeles | California | CA 90817 | [EMAIL] | +[PHONE] | [PHONE]
41 | Verhey41 | Verhey | Celestina | Celestina Verhey | 658 Shropshire Boulevard | Los Angeles | California | CA 90787 | [EMAIL] | +[PHONE] | [PHONE]
42 | Ohern42 | Ohern | Graig | [NAME] | 230 Shropshire Boulevard | Los Angeles | California | CA 90619 | [EMAIL] | +[PHONE] | [PHONE]
43 | Doan43 | Doan | Alec | Alec Doan | 182 Shropshire Boulevard | Los Angeles | California | CA 90606 | [EMAIL] | +[PHONE] | [PHONE]
44 | Prentice44 | Prentice | Mai | Mai Prentice | 637 Shropshire Boulevard | Los Angeles | California | CA 90788 | [EMAIL] | +[PHONE] | [PHONE]
45 | Rueb45 | Rueb | Nicola | Nicola Rueb | 1651 Shropshire Boulevard | Los Angeles | California | CA 90602 | [EMAIL] | +[PHONE] | [PHONE]
46 | Bradwell46 | Bradwell | [NAME] | [NAME] | 628 Shropshire Boulevard | Los Angeles | California | CA 90805 | [EMAIL] | +[PHONE] | [PHONE]
47 | Canela47 | Canela | Stephaine | Stephaine Canela | 533 Shropshire Boulevard | Los Angeles | California | CA 90805 | [EMAIL] | +[PHONE] | [PHONE]
48 | Schimmel48 | Schimmel | [NAME] | [NAME] | 511 Shropshire Boulevard | Los Angeles | California | CA 90644 | [EMAIL] | +[PHONE] | [PHONE]
49 | Coriell49 | Coriell | [NAME] | [NAME] | 199 Shropshire Boulevard | Los Angeles | California | CA 90749 | [EMAIL] | +[PHONE] | [PHONE]
50 | Knell50 | Knell | Carli | [NAME] | 604 [NAME] | Los Angeles | California | CA 90638 | [EMAIL] | +[PHONE] | [PHONE]