# Show only Matrix result

1. ## 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. ## 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. Hey JulieD,

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

Regards,
Emel

4. ## 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
>

#### Thread Information

##### Users Browsing this Thread

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

#### 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