- Joined
- Apr 14, 2008
- Messages
- 2
- Reaction score
- 0
Hi there,
My problem is I'm trying to force VLOOKUP to advance to the next option with the same number. I have a table full of varying flavors of values, but some of them are the same as others. I am creating a top ten list and I need to have it show what the row title of a given value is, but it is always retaining the same row title as the first value it pulls with VLOOKUP. Is there any way I can make it advance to the next option with the same number?
EX:
. . . . . . A . . . . . .B
1. . . . Value . . . . Name
2. . . . . 5 . . . . . Bob
3. . . . . 5 . . . . . Tom
4. . . . . 8 . . . . . Larry
5. . . . . 25 . . . . Jim
6. . . . . 1 . . . . . Tony
=VLOOKUP(LARGE(B2:B6,3),A2:B6,1,FALSE) <-- this returns the correct value "Bob"
=VLOOKUP(LARGE(B2:B6,4),A2:B6,1,FALSE) <-- this one needs to return the next value in the series, "Tom", but I haven't the slighest idea how to make it so.
My problem is I'm trying to force VLOOKUP to advance to the next option with the same number. I have a table full of varying flavors of values, but some of them are the same as others. I am creating a top ten list and I need to have it show what the row title of a given value is, but it is always retaining the same row title as the first value it pulls with VLOOKUP. Is there any way I can make it advance to the next option with the same number?
EX:
. . . . . . A . . . . . .B
1. . . . Value . . . . Name
2. . . . . 5 . . . . . Bob
3. . . . . 5 . . . . . Tom
4. . . . . 8 . . . . . Larry
5. . . . . 25 . . . . Jim
6. . . . . 1 . . . . . Tony
=VLOOKUP(LARGE(B2:B6,3),A2:B6,1,FALSE) <-- this returns the correct value "Bob"
=VLOOKUP(LARGE(B2:B6,4),A2:B6,1,FALSE) <-- this one needs to return the next value in the series, "Tom", but I haven't the slighest idea how to make it so.
Last edited: