I have a list of students eg John, Smith, Russel, Rahim, akbar, Sailja in Col. A from A1 to A6. In next column B their total marks from B1 to B6 eg. 348, 457, 389, 490, 391, 375 is present. I want to prepare a mark-sheet in the same work sheet where I can fetch names from data validation list but how the marks will automatically appear in next cell. Suppose I select the name of akbar in d5 how the total marks of akbar 490 shall automatically appear in e5 ?
I have a total list of more than 200 students and their total marks. Please give me a solution.

Please also suggest me how to prepare said mark sheet in another work sheet of same file