Put this in J3, press ctrl + shift + enter, and fill down:

=INDEX(Scores!$L$1:$L$500,SMALL(IF(Scores!
$K$1:$K$500="Padres",ROW(INDIRECT("1:500"))),ROW()-1))

HTH
Jason
Atlanta, GA

-----Original Message-----
I have a formula setup to look up a value in another
sheet and bring back a
value. Here is my formula in cell J2
=VLOOKUP("PADRES",Scores!K:N,2,0)

It works perfectly. However, there will be multiple
times Padres shows up
in the scores worksheet. How do I setup the formula so
in cells J3 it skips
the first occurance of Padres and finds the next one.
Then J4 finds the 3rd
occurance and so on. Thanks


.