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