+ Reply to Thread
Results 1 to 6 of 6

Match Numbers

  1. #1
    Forum Contributor
    Join Date
    04-02-2008
    Location
    Jacksonville Beach, Florida
    MS-Off Ver
    Microsoft Excel 2003 and 2010
    Posts
    264

    Match Numbers

    I am looking for a formula that matches two unique numbers in a table based on two numbers that are entered in two other cells. This will be clearer by looking at the example below and the attached.

    The goal is to find the number entered for the home field (cell c2) in the "home" row (B5:K5) with the number entered for the away field (cell c3) in the "away" column (A6:A15) and result in the data element where the row and columns come together. The expected result for this example in the attached would be "JPD".

    Another example would be if a 6 was in cell c2 and an 8 was in c3, the expected result would be "RBK". I think this can be done by indexing and matching but my memory has gone blank with how this works.

    Any help would be SUPER...no pun.
    Attached Files Attached Files
    Last edited by dreicer_Jarr; 02-07-2010 at 02:17 PM.

  2. #2
    Forum Moderator zbor's Avatar
    Join Date
    02-10-2009
    Location
    Croatia
    MS-Off Ver
    365 ProPlus
    Posts
    15,607

    Re: Match Numbers

    Like this? (If they are unique)

    =INDEX($B$6:$K$15;MATCH($C$3;$A$6:$A$15;0);MATCH(C2;$B$5:$K$5;0))

  3. #3
    Forum Contributor
    Join Date
    04-02-2008
    Location
    Jacksonville Beach, Florida
    MS-Off Ver
    Microsoft Excel 2003 and 2010
    Posts
    264

    Re: Match Numbers

    Maybe, but when I put that formula in cell F2, it is not working. Maybe see what happens when you enter it into f2? The attached should be pretty clear...

  4. #4
    Forum Moderator zbor's Avatar
    Join Date
    02-10-2009
    Location
    Croatia
    MS-Off Ver
    365 ProPlus
    Posts
    15,607

    Re: Match Numbers

    You probably need to replace ; with ,
    Attached Files Attached Files

  5. #5
    Forum Contributor
    Join Date
    04-02-2008
    Location
    Jacksonville Beach, Florida
    MS-Off Ver
    Microsoft Excel 2003 and 2010
    Posts
    264

    Re: Match Numbers

    I got it. Your formula worked perfectly when I replaced the semi-collons with commas. Is that an Excel version difference? I think I have 97.

  6. #6
    Forum Moderator zbor's Avatar
    Join Date
    02-10-2009
    Location
    Croatia
    MS-Off Ver
    365 ProPlus
    Posts
    15,607

    Re: Match Numbers

    No. It's just different regional settings. No matter on excel version.

+ 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