Large & Vlookup functions

[need a help]

i have problem when i have duplicate value in one column when i use vlookup
it will give only the last one and ignoring the others values so can you help
me and this is my work
SHEET1
A B C D
1 a Ron 10
2 b Tom 20
3 c Rod 30
4 d Bet 40
5 e Mic 40
6 f Lou 50
SHEET2
A B

1 VLOOKUP(LARGE(SHEET1!$A$3:$D$6,A1),SHEET1!$A$3:$D$6,3,FALSE)
it will give the resutl like
LOU
Mic
Mic
Bet
Rod
Tom
Ron
and it will ignore Bet because he has same value of Mic and Mic will come
tow times so is there any sulotion for this problem

 

[Office_Novice]

Maybe SUMPRODUCT
Good info here
http://www.contextures.com/xlFunctions01.html#SumProduct

 

[the_abcs]

You may need to add a new column A and do a concatenate of 3 or 4 columns to
get a unique ID to do a vlookup on.