If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
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 |
#2
|
|||
|
|||
Matrix selection
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. "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 |
#3
|
|||
|
|||
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 |
#4
|
|||
|
|||
Matrix selection
I your "private case": $A$1:$D$3 might be: A13
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 |
#5
|
|||
|
|||
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: A13 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 |
Thread Tools | |
Display Modes | |
|
|