{[ promptMessage ]}

Bookmark it

{[ promptMessage ]}

Data_Preparation_II_SOLUTION

use the blue shaded area above as the lookuparray in

Info icon This preview shows page 1. Sign up to view the full content.

View Full Document Right Arrow Icon
This is the end of the preview. Sign up to access the rest of the document.

Unformatted text preview: bove as the Lookup_Array in a VLOOKUP to correct the Region in the Purchasing Data worksheet CustomerCleansed SSNCleansed 1 539-84-9599 2 444-05-4079 3 418-18-5649 4 065-63-3311 5 059-58-9566 6 443-13-8685 7 638-89-7231 8 202-94-6453 9 266-29-0308 10 943-85-8301 11 047-07-5332 12 503-14-3400 13 690-97-5817 14 614-59-6703 15 704-98-5642 16 588-92-9590 17 267-58-0440 18 833-81-4506 19 645-20-8840 20 700-29-4704 21 443-16-6366 22 932-34-0537 23 943-09-9693 24 429-27-7896 25 977-81-8641 26 637-52-5564 27 208-24-5411 28 326-15-9711 29 437-20-5008 30 168-38-3752 31 564-00-1130 32 151-72-6670 33 508-92-0528 34 659-67-6522 35 166-81-0189 36 071-68-0276 37 498-98-3229 38 267-99-6806 39 356-51-5288 40 081-45-2678 41 006-59-5729 42 176-72-8671 43 053-13-0416 44 069-34-0131 45 710-56-1876 46 926-75-2882 47 601-10-4503 48 309-29-2521 49 539-79-0361 50 912-79-4136 51 669-39-4544 52 318-19-1132 53 300-80-8755 54 081-96-6992 55 183-43-4916 56 811-50-5929 57 380-14-0708 58 878-86-4832 59 716-43-4054 60 893-32-5390 61 104-36-4033 62 001-80-6937 63 ??? 64 ??? 65 745-24-4400 66 635-...
View Full Document

{[ snackBarMessage ]}

What students are saying

  • Left Quote Icon

    As a current student on this bumpy collegiate pathway, I stumbled upon Course Hero, where I can find study resources for nearly all my courses, get online help from tutors 24/7, and even share my old projects, papers, and lecture notes with other students.

    Student Picture

    Kiran Temple University Fox School of Business ‘17, Course Hero Intern

  • Left Quote Icon

    I cannot even describe how much Course Hero helped me this summer. It’s truly become something I can always rely on and help me. In the end, I was not only able to survive summer classes, but I was able to thrive thanks to Course Hero.

    Student Picture

    Dana University of Pennsylvania ‘17, Course Hero Intern

  • Left Quote Icon

    The ability to access any university’s resources through Course Hero proved invaluable in my case. I was behind on Tulane coursework and actually used UCLA’s materials to help me move forward and get everything together on time.

    Student Picture

    Jill Tulane University ‘16, Course Hero Intern