Show only Matrix result

E

emel24

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.
 
J

JulieD

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

IF and VLOOKUP functions for a matrix overview 4
SUMPRODUCT, SUM(IF(...), or some combination? 2
return multiple records matching multiple criteria 2
Return multiple records matching multiple criteria 7
Count unique with multiple criteria 3
How do you change font color based on the value input? 1 = <red>. 1
Sorting issue 3
populating cells using data from a different worksheet 4

Top