How to Auto Fill Cells in Excel based on a dependent drop down list?
<p>I have 2 sheets in sheet1 is the master sheet where all data are stored
In sheet2 I want to link the data of sheet1 in sheet2 in different cells</p>

<p>In Sheet1 I have 'Name' 'Mobile' 'Address' 'Pin' in A1 B1 C1 D1</p>

<p>In Sheet2 A2 I did data validation of the name of the persons which is stored in Sheet1, now I want that when I will select the respect list automatically the Mobile Address Pin of the person will auto fill in B2 C2 D2 </p>

<p>&amp; for that I am using the following formula </p>

<pre><code>=VLOOKUP($A2,Sheet1!$A:B,COLUMNS(Sheet1!$A:B),0)
</code></pre>

<p>If a person having 3 mobile numbers stored in my Sheet1, I want to place those 3 mobile numbers in my Sheet2 Mobile column, How do I do that ??</p>

<p>Column A is the main dependent, But if there are blank rows then Data validation doesn't work, how can I do that ??
or any macro required ?? </p>

<p><a href="https://i.stack.imgur.com/qzItf.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/qzItf.png" alt="Check the Image"></a></p>