Task2 - Vlookup Problems

Solve the attached Vlookup problems.

Problem - 1 :

Using ABC_Master sheet, solve the ABC_child sheet (Task1 and Task2)

13KB

ABC_Master.xlsx

10KB

ABC_Child.xlsx

Problem - 2 :

Using XYZ_Master sheet, solve the XYZ_child sheet (Task1)

13KB

XYZ_Master.xlsx

11KB

XYZ_Child.xlsx

Problem - 3 :

Replace the Lead_Source_Id, Prospect_Id, Source_Id columns in MASTER_DATA with the corresponding ID's in Lead Source, Prospect, Source Workbooks

567KB

MASTER_DATA.xlsx

360KB

LEAD SOURCE.csv

340KB

PROSPECT.csv

2KB

SOURCE.csv