I want to be able to find the nth value using VLOOKUP, INDEX, or something similar.
Example:
=VLOOKUP(2,A1:B5,2,0)
would return "Blue"
<tbody>
</tbody>
But, if I want it to find the 2nd "2" so that it returns "Red," how would I go about that?
Thanks!
Example:
=VLOOKUP(2,A1:B5,2,0)
would return "Blue"
A | B | |
1 | 3 | Green |
2 | 2 | Blue |
3 | 4 | Green |
4 | 2 | Red |
5 | 5 | Red |
<tbody>
</tbody>
But, if I want it to find the 2nd "2" so that it returns "Red," how would I go about that?
Thanks!