+ Reply to Thread
Results 1 to 4 of 4

Show only Matrix result

  1. #1
    Registered User
    Join Date
    02-16-2005
    Posts
    13

    Show only Matrix result

    I am using a Matrix on Sheet3 from A1:F6, with the following information:

    1 2 3 4 5
    A Low Low Low Med High
    B Low Low Med Med High
    C Low Low Med High High
    D Low Med Med High High
    E Med Med Med High High


    I would like to show the information in Sheet2 as a result on what I am chosen, for example using the fields A1 and B1 in Sheet2 with the entry of ‘A’ and ‘3’ should then show as a result in field C1 the criteria of ‘Low’.

    Can anyone please help me with the formula?

    Thanks in advance.

  2. #2
    JulieD
    Guest

    Re: Show only Matrix result

    Hi

    the formula in C1 would be
    =INDEX(Sheet3!A1:F6,MATCH(A1,Sheet3!A1:A6,0),MATCH(Sheet2!B1,Sheet3!A1:F1,0))

    Cheers
    JulieD

    "emel24" <emel24.1kjypm@excelforum-nospam.com> wrote in message
    news:emel24.1kjypm@excelforum-nospam.com...
    >
    > I am using a Matrix on Sheet3 from A1:F6, with the following
    > information:
    >
    > 1 2 3 4 5
    > A Low Low Low Med High
    > B Low Low Med Med High
    > C Low Low Med High High
    > D Low Med Med High High
    > E Med Med Med High High
    >
    >
    > I would like to show the information in Sheet2 as a result on what I am
    > chosen, for example using the fields A1 and B1 in Sheet2 with the entry
    > of 'A' and '3' should then show as a result in field C1 the criteria of
    > 'Low'.
    >
    > Can anyone please help me with the formula?
    >
    > Thanks in advance.
    >
    >
    > --
    > emel24
    > ------------------------------------------------------------------------
    > emel24's Profile:
    > http://www.excelforum.com/member.php...o&userid=20004
    > View this thread: http://www.excelforum.com/showthread...hreadid=345920
    >




  3. #3
    Registered User
    Join Date
    02-16-2005
    Posts
    13

    Thumbs up

    Hey JulieD,

    Thank you so much!
    You made my day !!!

    Regards,
    Emel

  4. #4
    JulieD
    Guest

    Re: Show only Matrix result

    i'm glad

    thanks for the feedback

    "emel24" <emel24.1kk2a8@excelforum-nospam.com> wrote in message
    news:emel24.1kk2a8@excelforum-nospam.com...
    >
    > Hey JulieD,
    >
    > Thank you so much!
    > You made my day !!!
    >
    > Regards,
    > Emel
    >
    >
    > --
    > emel24
    > ------------------------------------------------------------------------
    > emel24's Profile:
    > http://www.excelforum.com/member.php...o&userid=20004
    > View this thread: http://www.excelforum.com/showthread...hreadid=345920
    >




+ 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