R
Rj
I am looking for a way to look up duplicate values in a table array. When I
use VLOOKUP it continues to give me the same value (see D3 and D4).This is
the formula I used in
D140...=VLOOKUP(LARGE($A$1:$A$40,1),$A$1:$B$40,2,FALSE)
with the LARGE 'K' value incrementing. I would have liked D4 to come up with
FG04.
A B Formulas in C Column C D
1 32 FG01 =LARGE($A$1:$A$40,1) 41 FG03
2 22 FG02 =LARGE($A$1:$A$40,2) 32 FG01
3 41 FG03 =LARGE($A$1:$A$40,3) 22 FG02
4 22 FG04 =LARGE($A$1:$A$40,4) 22 FG02
5 12 FG05 =LARGE($A$1:$A$40,5) 12 FG05
use VLOOKUP it continues to give me the same value (see D3 and D4).This is
the formula I used in
D140...=VLOOKUP(LARGE($A$1:$A$40,1),$A$1:$B$40,2,FALSE)
with the LARGE 'K' value incrementing. I would have liked D4 to come up with
FG04.
A B Formulas in C Column C D
1 32 FG01 =LARGE($A$1:$A$40,1) 41 FG03
2 22 FG02 =LARGE($A$1:$A$40,2) 32 FG01
3 41 FG03 =LARGE($A$1:$A$40,3) 22 FG02
4 22 FG04 =LARGE($A$1:$A$40,4) 22 FG02
5 12 FG05 =LARGE($A$1:$A$40,5) 12 FG05