Home |
Search |
Today's Posts |
#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. -- emel24 ------------------------------------------------------------------------ emel24's Profile: http://www.excelforum.com/member.php...o&userid=20004 View this thread: http://www.excelforum.com/showthread...hreadid=345920 |
#2
|
|||
|
|||
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 |
#3
|
|||
|
|||
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 |
#4
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Amount or Numbers in Words | New Users to Excel | |||
Is there a formula to spell out a number in excel? | Excel Worksheet Functions | |||
Convert Numeric into Text | Excel Worksheet Functions | |||
Spellnumber | Excel Worksheet Functions | |||
Cell doesn't show formula result - it shows formula (CTRL + ' doe. | Excel Worksheet Functions |