find value in column F, then display value in column A of that
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
|