# Task2 - Vlookup Problems Solve the attached Vlookup problems. **Problem - 1 :** Using ABC\_Master sheet, solve the ABC\_child sheet (Task1 and Task2) {% file src="" %} ABC\_Master Data {% endfile %} {% file src="" %} ABC\_Child (To be solved) {% endfile %} **Problem - 2 :** Using XYZ\_Master sheet, solve the XYZ\_child sheet (Task1) {% file src="" %} XYZ\_Master Data {% endfile %} {% file src="" %} XYZ\_Child (To be solved) {% endfile %} **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 {% file src="" %} MASTER\_DATA (To be solved) {% endfile %} {% file src="" %} Lead Source {% endfile %} {% file src="" %} Prospect {% endfile %} {% file src="" %} Source {% endfile %}