Data_Preparation_II_SOLUTION

use the blue shaded area above as the lookuparray in

Info iconThis 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

This note was uploaded on 01/30/2014 for the course BUS-X 201 taught by Professor Goodrich during the Fall '08 term at Indiana.

Ask a homework question - tutors are online