+ Reply to Thread
Results 1 to 3 of 3

Match Competitor Score And Color

  1. #1
    Forum Contributor
    Join Date
    04-22-2011
    Location
    Isabela, Puerto Rico
    MS-Off Ver
    365 Mac Excel Version 16.54
    Posts
    233

    Match Competitor Score And Color

    Hi all,

    Need a formula to retrieve the competitors names and it's color from the score sheet.
    Names are on cells E11, E27, M11, M27, colors are on cells E10, E26, M10, M26
    The formula to retrieve the competitors names should be on L6:L9 matching their scores and color.
    The formula to retrieve their colors should be on D6:D9 matching their scores and color
    I have attached an example workbook for reference
    Thanks in advance for any help
    Last edited by score; 05-03-2011 at 11:28 PM.

  2. #2
    Forum Guru DonkeyOte's Avatar
    Join Date
    10-22-2008
    Location
    Northumberland, UK
    MS-Off Ver
    O365
    Posts
    21,531

    Re: Match Competitor Score And Color

    It might be simplest to just use embedded IFs, no ?

    Please Login or Register  to view this content.
    For Column D you would use the same formula as above, however, you would need to modify the outputs (E11 being E10, M11 being M10 etc...)

    You could use something more sophisticated than the above, however, with just four tests to perform I'm not sure it's worthwhile.

    The above does of course assume that the four scores are always unique.

    In reality the layout of your data is far from ideal.

  3. #3
    Forum Contributor
    Join Date
    04-22-2011
    Location
    Isabela, Puerto Rico
    MS-Off Ver
    365 Mac Excel Version 16.54
    Posts
    233

    Re: Match Competitor Score And Color

    DonkeyOte,

    Many thanks!!! it work perfect..

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

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