+ Reply to Thread
Results 1 to 2 of 2

Golf - Match Ranked number with Pairing number and disply golfers Name

  1. #1
    Registered User
    Join Date
    01-01-2014
    Location
    USA
    MS-Off Ver
    Excel 2010
    Posts
    33

    Golf - Match Ranked number with Pairing number and disply golfers Name

    I have a golf related spreadsheet - attached.
    I am trying to find a formula that will do the following: (have tried Match, Index, Etc)
    1. Column H - Match the row cell numbers in column H (H8-H31) this column has the High / Low Pairings for two-man teams within a foursome
    2. Column E - To the corresponding matching number in column E (E8-E31) this is the ranking based on actual score position
    3. Column I - Display the golfer's name from column D (D8-D31) into the cells in column I (I8-I31) that match the pairing number from column H

    The Actual Golf Score (in column C) is converted to a Ranked Position displayed in column E. I am trying to automatically get the corresponding golfers name (from column D) to display in column I based on the ranked position number displayed in column H.
    Attached Files Attached Files

  2. #2
    Forum Expert 63falcondude's Avatar
    Join Date
    08-22-2016
    Location
    USA
    MS-Off Ver
    365
    Posts
    6,266

    Re: Golf - Match Ranked number with Pairing number and disply golfers Name

    Try this:

    I8 =INDEX(D:D,MATCH(H8,E:E,0))

    Drag the formula down through I31.

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Replies: 2
    Last Post: 05-17-2016, 11:17 AM
  2. Golf score cards and pairing
    By wyowhite in forum Excel General
    Replies: 0
    Last Post: 04-19-2016, 04:13 PM
  3. Query date range and ref number match to return another reference number
    By 27paul0 in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 07-09-2015, 07:31 AM
  4. Replies: 5
    Last Post: 06-05-2013, 03:16 AM
  5. [SOLVED] Pairing up names based on their assigned number
    By hexr in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 02-06-2013, 07:33 PM
  6. [SOLVED] Count the number of duplicates in a range and then create a ranked sort
    By newbi004 in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 11-20-2012, 01:16 PM
  7. If number in culumn 'A' match set number another number in column 'I'
    By MAButler in forum Excel Programming / VBA / Macros
    Replies: 15
    Last Post: 04-10-2011, 08:29 PM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1