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
=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