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.


--
emel24
------------------------------------------------------------------------
emel24's Profile: http://www.excelforum.com/member.php...o&userid=20004
View this thread: http://www.excelforum.com/showthread...hreadid=345920

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" wrote in message
...

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

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

i'm glad :)

thanks for the feedback

"emel24" wrote in message
...

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