Use of VLOOKUP for multivalue cells

[AmitD]

Hi,

Following is the list of students & marks they've got in exam. This is sample. We are having groups like A&B, C&D, E&F. We can allow only one from each group who is having more marks for next test. Kindly suggest, how the formula should be using vlookup? Thanks in advance
[TABLE="width: 288"]
<colgroup><col width="72" span="4" style="width:54pt"> </colgroup><tbody>[TR]
[TD="width: 72"]1[/TD]
[TD="width: 72"]A[/TD]
[TD="width: 72"]B[/TD]
[TD="width: 72"]C[/TD]
[/TR]
[TR]
[TD]2[/TD]
[TD="class: xl77"]Sr[/TD]
[TD="class: xl77"]Name[/TD]
[TD="class: xl77"]Marks[/TD]
[/TR]
[TR]
[TD]3[/TD]
[TD="class: xl77"]1[/TD]
[TD="class: xl77"]A[/TD]
[TD="class: xl77"]15[/TD]
[/TR]
[TR]
[TD]4[/TD]
[TD="class: xl77"]2[/TD]
[TD="class: xl77"]B[/TD]
[TD="class: xl77"]20[/TD]
[/TR]
[TR]
[TD]5[/TD]
[TD="class: xl77"]3[/TD]
[TD="class: xl77"]C[/TD]
[TD="class: xl77"]11[/TD]
[/TR]
[TR]
[TD]6[/TD]
[TD="class: xl77"]4[/TD]
[TD="class: xl77"]D[/TD]
[TD="class: xl77"]16[/TD]
[/TR]
[TR]
[TD]7[/TD]
[TD="class: xl77"]5[/TD]
[TD="class: xl77"]E[/TD]
[TD="class: xl77"]18[/TD]
[/TR]
[TR]
[TD]8[/TD]
[TD="class: xl77"]6[/TD]
[TD="class: xl77"]F[/TD]
[TD="class: xl77"]19[/TD]
[/TR]
</tbody>[/TABLE]

 

[ravishankar]

try =INDIRECT("C" & MATCH(LARGE(D2:D7,1),D1:D7,0))
ravishankar

 

[Aladin Akyurek]

Hard to follow. Please provide an example or two of what you want to calculate or retrieve.