Ok, got it!

Enter this array formula in BestBall!A4:

=INDEX(Entry!$A$4:$A$153,SMALL(IF(Entry!$F$4:$F$15 3="bb"&ROWS($1:1),ROW(A$4:A$153)-ROW(A$4)+1),COLUMNS($A:A)))

Copy across to B4 then down for 75 rows.

You'll get 75 2-man pairings in ascending order.

Biff

"rc" wrote in message
...
This is getting close, but still not exactly what I need to do. Maybe this
will help me clarify:

In Entry!A4:A153 are names of golfers playing in a tournament. This
workbook
does many scoring calculations for each player individually on several
worksheets, however I'd like to add a new worksheet called BestBall, where
I'm attempting to pair golfers into teams.

So, Entry!F4:F153 will contain two bb1 flags for the first pairing, two
bb2
flags for the second pairing, and so on.

By telling BestBallA4:A153 to find the flags in Entry!F4:F153, I'm hoping
to
display those pairings.

I hope this helps to convey my goal.

Thanks,

rc