auto fill into rows

[Grahamscown]

in my work book 1 have 5 columns column F is NAME column G is COMPANY column H is MOBILE NO column I is ID NUMBER column J is KEY NO What i am trying to do is when i type in a name into a cell in the name column the other info autofils into the other columns in rows the columns A TO E Will be filled out manually

 

[Grahamscown]

And One other Things I understand, Why you have repeated data at Name Column at Source sheet? (Based Post #12)
Then How We know which one should be filled at Other Columns.
Vlookup work based Unique items at Name Column.
With Unique Item at Column Name at Sheet1 this is example file I uploaded. See Sheet2 to view Results:
Test1.xlsx

Yes post 12 was a mistake i did not realise it was duplicated until i just looked As of today i am still stuck in the same place i put the formula into G2 and hit enter Then with the cross on the corner of the cell i drag it across to J2 . and i can see still the formula in the 4 cells as seen in image the calculation is set at automatic im still not sure what i am doing wrong

 

[maabadi]

I see at your uploaded file one more Space at the start of formula. Delete it and Press Enter. Then Drag it to J2 & Again Drag all to Last row of your Table.
I also uploaded example file at previous post (Post #20). Download and see it also.