Part 1: Add the Credit Line information from Source 3 to Full Set We are changing the original credit line policy so that a minimum credit line of $2,000 is being established, even if the customer had an original credit line of $0, it is now changed to $2,000. Create a new column called New Credit Line in Source 3 worksheet to reflect these changes. Use the VLOOKUP() function to put this updated information into the Full Set worksheet. You will notice that even if you do it correctly, there will be some errors (N/A values). How would I go about doing this in excel?

1 Customer Name Original Credit Line Missed Payments Country Country 2 2 Allan Strate $10,000.00 1 USA United States 3 Cathrine Delamater $20,000.00 3 USA United States 4 Christin Tillinghast $8,000.00 5 United States United States 5 Daniela Becknell $10,000.00 o United States United States 6. Darryl Manuelito $10,000.00 O US United States 7 Eleanor Aburto $10,000.00 O Canada Canada 8 Elnora Willison $20,000.00 3 US United States 9 Erik Vire $0.00 O US United States 10 Eve Haak $5,000.00 o United States United States 11 Jamie Sabat $5,000.00 O Canada Canada 12 Jamie Woodbridge $5,000.00 5 USA United States 13 Julio Willard $10,000.00 O USA United States 14 Kisha Grauer $7,500.00 O USA United States 15 Leota Vonderheide $7,500.00 3 USA United States 16 Lonnie Ludy $10,000.00 2 USA United States 17 Max Kindle $10,000.00 O USA United States 18 Milagros Fehrenbach $0.00 O USA United States 19 Odessa Smith $20,000.00 O USA United States 20 Roslyn Plott $20,000.00 O US United States 21 Roxie Prewitt $20,000.00 3 US United States 22 Suzan Plock $7,500.00 O US United States 23 Tyrone Hine $20,000.00 2 US United States Source 1 Source 2 Full Set Lookups Source 3 1 Customer Name Original Credit Line Missed Payments Country Country 2 2 Allan Strate $10,000.00 1 USA United States 3 Cathrine Delamater $20,000.00 3 USA United States 4 Christin Tillinghast $8,000.00 5 United States United States 5 Daniela Becknell $10,000.00 o United States United States 6. Darryl Manuelito $10,000.00 O US United States 7 Eleanor Aburto $10,000.00 O Canada Canada 8 Elnora Willison $20,000.00 3 US United States 9 Erik Vire $0.00 O US United States 10 Eve Haak $5,000.00 o United States United States 11 Jamie Sabat $5,000.00 O Canada Canada 12 Jamie Woodbridge $5,000.00 5 USA United States 13 Julio Willard $10,000.00 O USA United States 14 Kisha Grauer $7,500.00 O USA United States 15 Leota Vonderheide $7,500.00 3 USA United States 16 Lonnie Ludy $10,000.00 2 USA United States 17 Max Kindle $10,000.00 O USA United States 18 Milagros Fehrenbach $0.00 O USA United States 19 Odessa Smith $20,000.00 O USA United States 20 Roslyn Plott $20,000.00 O US United States 21 Roxie Prewitt $20,000.00 3 US United States 22 Suzan Plock $7,500.00 O US United States 23 Tyrone Hine $20,000.00 2 US United States Source 1 Source 2 Full Set Lookups Source 3