View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.worksheet.functions
rc
 
Posts: n/a
Default 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