Spreadsheet: 536750d1504665125-take-column-from-one-worksheet-and-match-its-info-with-cells-in-another-sheet-hfa_all_contacts_08-04-2017-copy
Sheet: HFA_RC-Created Contact-Accounts

Company | Loan Number | Lead Type | Client Lead ID | Street | City | State/Province | Zip/Postal Code | Country | Work Phone | Banker Extension | [NAME] | Account Buying Group | Number of Employees | Number of Locations | Annual Sales Volume Range | Social Media Handles | Facebook | Instagram | Twitter | Point of Sales Solution | Web Provider | Communication Preference | Record Updated | Call Result
371 Furniture | X | AEHFAM | 1213499 | X | Brainerd | MN | X |  | X |  | X | HFA Buying Source | 5 |  | Under 1 Million |  |  |  |  |  |  |  | 0 | Validated
Ahn's Piano | X | AEHFAM | 1188860 | X | Los Angeles | CA | X |  | X |  | X |  | 4 | 2 | Under 1 Million |  |  |  |  | Manual |  |  | 1 | Validated
Alexander Home Collection | X | AEHFAM | 1213898 | X | Santa Rosa | CA | X |  | X |  | X | HFA Buying Source | 3 |  | Under 1 Million |  |  |  |  |  |  |  | 0 | Validated
American Oak Wholesalers & Auction Co | X | AEHFAM | 10172 | X | Paso Robles | CA | X |  | X |  | X | HFA Buying Source | 0 | 1 | Under 1 Million |  |  |  |  |  |  |  | 0 | Validated
American Sleep Center | X | AEHFAM | 52053N | X | Lancaster | PA | X |  | X |  | X | HFA Buying Source | 5 | 0 | Under 1 Million |  |  |  |  |  |  |  | 0 | Validated
American Wholesale Furniture | X | AEHFAM | 10176 | X | [NAME] | CA | X |  | X |  | X | HFA Buying Source | 0 | 2 | Under 1 Million |  |  |  |  |  |  |  | 0 | Validated
[NAME] | X | AEHFAM | 50255N | X | Urbandale | IA | X |  | X |  | X | HFA Buying Source | 7 | 1 | Under 1 Million |  | [NAME] |  |  | credit card | private contract | Phone | 1 | Validated
Arvel | X | AEHFAM | 1213957 | X | Tomball | TX | X |  | X | 104 | X | HFA Buying Source | 46 | 2 | Under 1 Million |  |  |  |  |  |  |  | 0 | Validated
Ashley Furniture HomeStore | X | AEHFAM | 14072N | X | Jacksonville | FL | X |  | X |  | X |  | 25 | 0 | Under 1 Million |  |  |  |  |  |  |  | 0 | Validated
Ask Amy Staging | X | AEHFAM | 1208487 | X | Botkins | OH | X |  | X |  | X | HFA Buying Source | 10 | 1 |  |  | Ask Amy Staging | Ask Amy Staging |  | rio |  |  | 1 | Validated
Aven Furniture | X | AEHFAM | 10330 | X | Lancaster | CA | X |  | X |  | X | HFA Buying Source | 0 | 0 | Under 1 Million |  |  |  |  |  |  | [NAME] | 1 | Validated
Azteca Home Furniture | X | AEHFAM | 10340 | X | Cathedral City | CA | X |  | X |  | X | HFA Buying Source | 5 | 0 | Under 1 Million |  |  |  |  |  |  | [NAME] | 1 | Validated
B & M Floors | X | AEHFAM | 14206N | X | Seneca | PA | X |  | X |  | X | HFA Buying Source | 0 | 0 | Under 1 Million |  |  |  |  |  |  |  | 1 | Validated
B & M Floors | X | AEHFAM | 14206N | X | Seneca | PA | X |  | X |  | X | HFA Buying Source | 0 | 0 | Under 1 Million |  |  |  |  |  |  |  | 1 | Validated
Bachman Furniture | X | AEHFAM | 1143267 | X | Milwaukee | WI | X |  | X |  | X | HFA Buying Source | 17 | 1 | Under 1 Million |  |  |  |  |  |  |  | 0 | Validated
Back at the Ranch Home Furnishings | X | AEHFAM | 10369 | X | Gunnison | CO | X |  | X |  | X | HFA Buying Source | 7 | 1 | Under 1 Million |  |  |  |  |  |  |  | 0 | Validated
Banfich Interiors | X | AEHFAM | 49026N | X | Plymouth | IN | X |  | X |  | X | Mega USA | 6 | 0 | Under 1 Million |  |  |  |  |  |  | [NAME] | 1 | Validated
Bare Wood Fine Wood Furniture | X | AEHFAM | 1197550 | X | [NAME] | CT | X |  | X |  | X | HFA Buying Source | 0 | 0 | Under 1 Million |  |  |  |  |  |  |  | 0 | Validated - Change of Ownership
Barr's Furniture | X | AEHFAM | 10437 | X | Riverside | CA | X |  | X |  | X | HFA Buying Source | 8 | 1 | Under 1 Million |  | Barr's Furniture | Barr's Furniture | @BarrsFurniture | CDS |  |  | 1 | Validated
Bass Furniture & Rug Co | X | AEHFAM | 31837N | X | Chicago | IL | X |  | X |  | X | HFA Buying Source | 0 | 1 | Under 1 Million |  |  |  |  |  |  |  | 0 | Validated
Bassett Furniture Direct | X | AEHFAM | 10455 | X | Grand Junction | CO | X |  | X |  | X |  | 7 | 1 | Under 1 Million |  |  |  |  |  |  | [NAME] | 1 | Validated
Bauer Furniture | X | AEHFAM | 1143220 | X | Carthage | TX | X |  | X |  | X |  | 5 | 1 | Under 1 Million |  |  |  |  |  |  | [NAME] | 1 | Validated
[NAME] | X | AEHFAM | 39024N | X | South Haven | MI | X |  | X |  | X | HFA Buying Source | 9 | 1 | Under 1 Million |  |  |  |  |  |  |  | 0 | Validated
Best Price Furniture | X | AEHFAM | 10581 | X | Redwood City | CA | X |  | X |  | X | HFA Buying Source | 0 | 1 | Under 1 Million |  |  |  |  |  |  |  | 0 | Validated
Best Price Furniture | X | AEHFAM | 10581 | X | Redwood City | CA | X |  | X |  | X | HFA Buying Source | 0 | 1 | Under 1 Million |  |  |  |  |  |  |  | 0 | Validated
Blake Furniture | X | AEHFAM | 1143217 | X | Longview | TX | X |  | X |  | X | HFA Buying Source, Nationwide | 6 | 10 | Under 1 Million |  |  |  |  |  |  |  | 0 | Validated
Blind Builders Inc | X | AEHFAM | 29450 | X | [NAME] | PA | X |  | X |  | X |  | 0 | 0 | Under 1 Million |  |  |  |  |  |  |  | 0 | Validated
Blocker's Furniture | X | AEHFAM | 1143292 | X | Immokalee | FL | X |  | X |  | X | Mega USA | 15 | 2 | Under 1 Million |  |  |  |  |  |  |  | 0 | Validated
Blue Hill Furniture | X | AEHFAM | 15199N | X | Blue Hill | NE | X |  | X |  | X | HFA Buying Source | 2 | 0 | Under 1 Million |  |  |  |  |  |  |  | 0 | Validated
Boones Furniture & Gifts | X | AEHFAM | 664N | X | Burlington | NC | X |  | X |  | X | HFA Buying Source/vendor | 0 | 1 | Under 1 Million |  | Boones Furniture & Gifts |  |  | credit card |  |  | 1 | Validated
Bordona's Oakdale Furniture | X | AEHFAM | 1093320 | X | Oakdale | CA | X |  | X |  | X | BrandSource | 15 | 0 | Under 1 Million |  |  |  |  |  |  |  | 0 | Validated
Bridgman Furniture | X | AEHFAM | 1143164 | X | Poteau | OK | X |  | X |  | X | HFA Buying Source | 5 | 1 | Under 1 Million |  |  |  |  |  |  | Phone | 1 | Validated
Castle Furniture LLC | X | AEHFAM | 36783N | X | Houston | TX | X |  | X |  | X | HFA Buying Source, Nationwide | 7 | 0 | Under 1 Million |  |  |  |  |  |  |  | 0 | Validated
Cedar Hill Design Center | X | AEHFAM | 1210492 | X | Cedar Hill | TX | X |  | X |  | X | HFA Buying Source | 5 | 0 | Under 1 Million |  |  |  |  |  |  |  | 0 | Validated
Central Hardware & Furniture | X | AEHFAM | 1210833 | X | Ironton | OH | X |  | X |  | X | HFA Buying Source | 2 | 1 | Under 1 Million |  | Central Hardware & Furniture |  |  | Paladin |  |  | 1 | Validated
A Royal Suite | X | AEHFAM | 10025 | X | Santa Clarita | CA | X |  | X |  | X | HFA Buying Source | 25 | 2 | 1-4 Million |  |  |  |  |  |  |  | 0 | Validated
ABC Furniture | X | AEHFAM | 1005880 | X | Waipahu | HI | X |  | X |  | X | HFA Buying Source | 16 | 1 | 1-4 Million |  |  |  |  | Quickbooks | FB - ABC Warehouse | [NAME] | 1 | Validated
Adams Furniture | X | AEHFAM | 51569N | X | [NAME] | MA | X |  | X |  | X | HFA Buying Source | 0 | 0 | 1-4 Million |  |  |  |  |  |  |  | 0 | Not Validated - No Longer Current Contact
Affordable Furniture | X | AEHFAM | 10072 | X | Bakersfield | CA | X |  | X |  | X | HFA Buying Source | 10 | 1 | 1-4 Million |  |  |  |  |  |  |  | 0 | Validated
Aladdin Home Store | X | AEHFAM | 48322N | X | [NAME] | TX | X |  | X |  | X | Furniture First | 14 | 1 | 1-4 Million |  |  |  |  |  |  |  | 0 | Validated
American Furniture Galleries | X | AEHFAM | 10139 | X | Sacramento | CA | X |  | X |  | X | PFD | 100 | 4 | 1-4 Million |  |  |  |  |  |  |  | 0 | Validated
American Furniture Warehouse | X | AEHFAM | 10151 | X | Englewood | CO | X |  | X |  | X |  | 2800 | 14 | 100+ Million | Facebook, [NAME], [NAME] |  |  |  | Stories |  |  | 1 | Validated
American Furniture Warehouse | X | AEHFAM | 1211658 | X | Greensboro | NC | X |  | X |  |  | HFA Buying Source, Nationwide | 0 | 0 | 1-4 Million |  |  |  |  |  |  |  | 0 | Validated
American Home Store Outlets | X | AEHFAM | 13671N | X | [NAME] | IN | X |  | X |  | X | HFA Buying Source | 25 | 0 | 1-4 Million |  |  |  |  |  |  |  | 0 | Validated
AMI / Furniture Leaders | X | AEHFAM | 10181 | X | Belgrade | MT | X |  | X |  | X | AMI | 0 | 0 | 16-30 Million |  |  |  |  |  |  | [NAME] | 1 | Validated
[NAME] | X | AEHFAM | 32743N | X | Franklin | PA | X |  | X |  | X | HFA Buying Source, Mega USA | 12 | 2 | 1-4 Million |  |  |  |  | Genesis | Web Fonts | [NAME] | 1 | Validated
Arnwines Home Furnishings Inc | X | AEHFAM | 13939N | X | Knoxville | TN | X |  | X |  | X |  | 5 | 1 | 1-4 Million | Facebook, Arnwines.com |  |  |  | Manual | SlimDot |  | 1 | Validated
B & L Furniture & Appliance | X | AEHFAM | 14205N | X | Vansant | VA | X |  | X |  | X | Mega USA | 10 | 1 | 1-4 Million |  |  |  |  |  |  |  | 0 | Validated