Matrix selection

[Marco Rod]

Hello,

I have a problem and I need a solution that I'm not finding out. I need a
formula that give me a specific value in a matrix (under the condition of
column and row).

Example: I have the matrix described below. I need a formula that gives me
how many keybords has room 1. Of course that the formula must allow me to
change the conditions of the serach.

Advisors PC Mouse keybord
Room 1 20 30 40
Room 2 30 67 90

Thanks in Advance for your support
Regards
Marco

 

[Mike H]

Hi,

Try this

=INDEX(A120, MATCH(F1,A1:A20,0), MATCH(G1,A11,0))

Where

A120 is the full table including header rows and columns
Lookup value for Column in F1
Lookup value for row is in g1

the formula returns the intersect
--
Mike

When competing hypotheses are otherwise equal, adopt the hypothesis that
introduces the fewest assumptions while still sufficiently answering the
question.

 

[מיכ×ל (מיקי) ×בידן]

Two more solutions:
http://img35.imageshack.us/img35/2750/nonamecr.png
Micky

 

[מיכ×ל (מיקי) ×בידן]

I your "private case": $A$1:$D$3 might be: A13
Micky

 

[Marco Rod]

Thanks a lot. It works perfectly both solutions.

Once again, Thanks a lot

Marco Rod

"מיכ×ל (מיקי) ×בידן" escreveu: