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
Bookmarks