Hi All
hope you're all well?
Is it possible to have an index(match look at and retrieve the value of the nth occurrence in an array?
For example. if in Column A I have:
Cat
Dog
Cat
Monkey
Elephant
then in column B I have:
1
3
5
6
8
I want my index match to return the value of the 2nd occurence of Cat (so, 5), how could I do this please?
would return 1
Many thanks in advance for your help!![Smile :) :)](https://cdn.jsdelivr.net/joypixels/assets/8.0/png/unicode/64/1f642.png)
hope you're all well?
Is it possible to have an index(match look at and retrieve the value of the nth occurrence in an array?
For example. if in Column A I have:
Cat
Dog
Cat
Monkey
Elephant
then in column B I have:
1
3
5
6
8
I want my index match to return the value of the 2nd occurence of Cat (so, 5), how could I do this please?
Code:
=INDEX(A1:B5,MATCH("Cat",A1:A5,0),2)
Many thanks in advance for your help!
![Smile :) :)](https://cdn.jsdelivr.net/joypixels/assets/8.0/png/unicode/64/1f642.png)