Jason Morin provided me with the following formula

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

This accomplished what I wanted but I am looking for something that will do
it automatically instead of me having to replace the x with the number I
want.

I want this formula to work in cells J3, J8-J13, J18-J23. Does anyone know
a way to change the formula or a different formula that will do this for me?
Thanks.


My original help question that Jason answered is called vlookup help...
See this if you need more information as to what I am looking for. Thanks