Large & Vlookup functions
 

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

Large & Vlookup functions
 

Maybe SUMPRODUCT
Good info here
http://www.contextures.com/xlFunctio...tml#SumProduct

"need a help" wrote:

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

Large & Vlookup functions
 

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.

"need a help" wrote:

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