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

ABC_Master Data

10KB

ABC_Child.xlsx

ABC_Child (To be solved)

Problem - 2 :

Using XYZ_Master sheet, solve the XYZ_child sheet (Task1)

13KB

XYZ_Master.xlsx

XYZ_Master Data

11KB

XYZ_Child.xlsx

XYZ_Child (To be solved)

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

MASTER_DATA (To be solved)

360KB

LEAD SOURCE.csv

Lead Source

340KB

PROSPECT.csv

Prospect

2KB

SOURCE.csv

Source