2nd occurance using index and match formula

[edward91]

Hi just asking how do i use the match and index formula to display the all e list of the items? i using microsoft excel 2003 btw

=INDEX(Data!$C$5:$C$200,MATCH(F9&M6&N6,Data!$G$5:$G$200&Data!$A$5:$A$200&Data!$O$5:$O$200,0))


this is the formula i use for my 1st occurance.
i trying to display the 2nd and 3rd and so on

 

[Robert Mika]

Looking here
http://www.mrexcel.com/forum/showthread.php?p=2263339#post2263339
you will fid an example how to return more that one match in diffrent cells
Not sure if that the way you are looking - the best way is to post some data.

 

[shemayisroel]

If your question is how do you return all values from a lookup then the below post will help you with the set up/solution

http://www.mrexcel.com/forum/showthread.php?t=362743