How to make Vlookup return next match

[romeo16]

[TABLE="class: grid, width: 100"]
<tbody>[TR]
[TD]Names[/TD]
[TD]Age[/TD]
[/TR]
[TR]
[TD]25[/TD]
[TD]A[/TD]
[/TR]
[TR]
[TD]18[/TD]
[TD]B[/TD]
[/TR]
[TR]
[TD]25[/TD]
[TD]C[/TD]
[/TR]
[TR]
[TD]30[/TD]
[TD]D[/TD]
[/TR]
</tbody>[/TABLE]
I have a huge table but I just made this as a sample of my scenario , so I used LARGE() to return first three Old ages and this was the result which makes sense.

[TABLE="class: grid, width: 80"]
<tbody>[TR]
[TD]30[/TD]
[/TR]
[TR]
[TD]25[/TD]
[/TR]
[TR]
[TD]25[/TD]
[/TR]
</tbody>[/TABLE]

And then I want to return the corresponding value (Name) from the first table . I used Vlookup but If you know another function that can work better . Vlookup result was like this

[TABLE="class: grid, width: 50"]
<tbody>[TR]
[TD]A[/TD]
[/TR]
[TR]
[TD]A[/TD]
[/TR]
[TR]
[TD]D[/TD]
[/TR]
</tbody>[/TABLE]

And I want it to be as below

[TABLE="class: grid, width: 50"]
<tbody>[TR]
[TD]A[/TD]
[/TR]
[TR]
[TD]C[/TD]
[/TR]
[TR]
[TD]D[/TD]
[/TR]
</tbody>[/TABLE]

Any help will much appreciated. Thanks

 

[romeo16]

Perfect I understand now , I will post another problem very soon Thanks Eric and Wibeboydixon

 

[romeo16]

Thank you, WBD! I knew you'd be able to help, with that brain the size of a planet!

Romeo, let us know if you have any other questions.

, Hi eric, here is another question --> http://www.mrexcel.com/forum/excel-questions/956362-make-index-match-accurate.html#post4593406

 

[romeo16]

SMALL({array}, n) returns the "nth" smallest value from the array and won't include FALSE. In this case, n = 2 so it returns the second smallest number = 3.

WBD

Hi WBD, here is another question --> http://www.mrexcel.com/forum/excel-questions/956362-make-index-match-accurate.html#post4593406