Glad you sorted it out, Brady.

=INDEX(A:A,MATCH(SMALL(AD:AD,ROW(A3)),AD:AD,0))
To
=INDEX(A:A,MATCH(SMALL(AD:AD,ROW(A1)),AD:AD,0))

Yes, that's right. Use ROW(A1) for the formula in the starting cell,
irrespective of where this cell may be. ROW(A1) is used here as an
incrementer, to return the sequential series: 1, 2, 3 ... as we copy the
formula down. To see this, just put in any cell: =ROW(A1), then copy down.
To propagate likewise when copying formulas across, we could use COLUMN(A1).
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---
"Brady" wrote:
Max,

Nevermind. I figured it out! I'm still not sure how it works but I
did figure out how to make it do what I want.

I changed
=INDEX(A:A,MATCH(SMALL(AD:AD,ROW(A3)),AD:AD,0))
To
=INDEX(A:A,MATCH(SMALL(AD:AD,ROW(A1)),AD:AD,0))

AND
=IF(P3="","",IF(P2="Y",ROW(),""))
To
=IF(P3="","",IF(P3="Y",ROW(),""))

....and all is well.

Thanks again!