Need to return second occurance

[Californiaoc]

I'm using the OFFSET and MATCH functions to find a value in an array but
I'm also trying to find a second, third, and fourth occurance of the
same lookup value and the function will only return the first match.
How can I return the value of the second match and the third match,
etc.?

 

[RagDyer]

This old post should give you some help:

http://tinyurl.com/2lakm
--

HTH,

RD
==============================================
Please keep all correspondence within the Group, so all may benefit!
==============================================

message I'm using the OFFSET and MATCH functions to find a value in an array but
I'm also trying to find a second, third, and fourth occurance of the
same lookup value and the function will only return the first match.
How can I return the value of the second match and the third match,
etc.?

 

[Californiaoc]

Thank you for your help. The advance filter seems to be the way t
accomplish this in the most simple way. I appreciate your help.

Dav