Matrix selection
 

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

Matrix selection
 

Hi,

Try this

=INDEX(A1:D20, MATCH(F1,A1:A20,0), MATCH(G1,A1:D1,0))

Where

A1:D20 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.


"Marco Rod" wrote:

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

Matrix selection
 

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


"Marco Rod" wrote:

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

Matrix selection
 

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


"מיכאל (מיקי) אבידן" wrote:

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


"Marco Rod" wrote:

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

Matrix selection
 

Thanks a lot. It works perfectly both solutions.

Once again, Thanks a lot

Marco Rod

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

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


"מיכאל (מיקי) אבידן" wrote:

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


"Marco Rod" wrote:

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