> For the complete documentation index, see [llms.txt](https://books-gyansetu.gitbook.io/advanced-excel/llms.txt). Markdown versions of documentation pages are available by appending `.md` to page URLs; this page is available as [Markdown](https://books-gyansetu.gitbook.io/advanced-excel/task2-vlookup-problems.md).

# Task2 - Vlookup Problems

Solve the attached Vlookup problems.

**Problem - 1 :**

Using ABC\_Master sheet, solve the ABC\_child sheet (Task1 and Task2)

{% file src="/files/-LRwAHdz9Aa8FBfbTfQN" %}
ABC\_Master Data
{% endfile %}

{% file src="/files/-LRwAOyeMWqtI5Tg1NAv" %}
ABC\_Child (To be solved)
{% endfile %}

**Problem - 2 :**

Using XYZ\_Master sheet, solve the XYZ\_child sheet (Task1)

{% file src="/files/-LRwB1em\_1YkIrEpwS3Y" %}
XYZ\_Master Data
{% endfile %}

{% file src="/files/-LRwB7FP04C5Xrx-sUHN" %}
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="/files/-LRwCq6xOQ-bJY\_8K0LT" %}
MASTER\_DATA (To be solved)
{% endfile %}

{% file src="/files/-LRwD2ZomVERYrnrcdi4" %}
Lead Source
{% endfile %}

{% file src="/files/-LRwDAWdj77MzCfyVrML" %}
Prospect
{% endfile %}

{% file src="/files/-LRwDGcl7bbew53XsD2Q" %}
Source
{% endfile %}