+ Reply to Thread
Results 1 to 4 of 4

Index/Match Solution?

  1. #1
    Registered User
    Join Date
    05-08-2004
    Posts
    16

    Index/Match Solution?

    Looking at other posts, I keeping thinking I'm coming close to a solution but can't seem to figure it out.

    I have a range of values, say: A2:J2
    and
    I have corresponding text labels for these values: A1:J1

    I want to identify the smallest value ( MIN(A2:J2) ) and populate another cell (say A4) with the corresponding text label that identifies the smallest value (i.e. if MIN(A2:J2) is the value in cell E2, then I want cell A4 to contain the text value of E1)

    I’m sure I’ve circled around the solution a few times, any help will be appreciated.

    Thanks,
    --Robert-->

  2. #2
    Max
    Guest

    Re: Index/Match Solution?

    One way, assuming no ties* in the min. values within A2:J2

    Placed in A4:
    =INDEX(A1:J1,MATCH(MIN(A2:J2),A2:J2,0))

    will retrieve the label within A1:J1 corresponding
    to the min. value within A2:J2

    *If there are any ties, only the leftmost label will be retrieved
    --
    Max
    Singapore
    http://savefile.com/projects/236895
    xdemechanik
    ---
    "WeatherGuy" <[email protected]> wrote
    in message news:[email protected]...
    >
    > Looking at other posts, I keeping thinking I'm coming close to a
    > solution but can't seem to figure it out.
    >
    > I have a range of values, say: A2:J2
    > and
    > I have corresponding text labels for these values: A1:J1
    >
    > I want to identify the smallest value ( MIN(A2:J2) ) and populate
    > another cell (say A4) with the corresponding text label that identifies
    > the smallest value (i.e. if MIN(A2:J2) is the value in cell E2, then I
    > want cell A4 to contain the text value of E1)
    >
    > I’m sure I’ve circled around the solution a few times, any help will be
    > appreciated.
    >
    > Thanks,
    > --Robert-->
    >
    >
    > --
    > WeatherGuy
    > ------------------------------------------------------------------------
    > WeatherGuy's Profile:

    http://www.excelforum.com/member.php...fo&userid=9254
    > View this thread: http://www.excelforum.com/showthread...hreadid=506628
    >




  3. #3
    Registered User
    Join Date
    05-08-2004
    Posts
    16
    That will work great. Thanks a bunch!

  4. #4
    Max
    Guest

    Re: Index/Match Solution?

    You're welcome !
    Thanks for the feedback ..
    --
    Max
    Singapore
    http://savefile.com/projects/236895
    xdemechanik
    ---
    "WeatherGuy" <[email protected]> wrote
    in message news:[email protected]...
    >
    > That will work great. Thanks a bunch!




+ 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