Grab Data from more than one column Based on Selection from List in a different sheet

Hi,

I really need help with this. I have tried the below tutorials but the results are not what I need.

http://www.contextures.com/xlDataVal02.html
http://trumpexcel.com/2013/07/creati...rop-down-list/


Based on What Name is selected from a Drop down List on Sheet 1 Column A (Name Stored on Sheet2), I want it to grab all data that matches the name Selected that is on the same Row of the name matched from Sheet 2 and display on Sheet 1

Please see Example of made up data attached

So what ever Name you select from Column A on Sheet 1 it Finds and Matches ON Sheet 2 it populates Column B and C on Sheet 1 with the correct info that was on the same row on Sheet 2 as the name you selected

Any help would be much appreciated


Thanks