Matrix selection

M

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
 
M

Mike H

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

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

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

Marco Rod

Thanks a lot. It works perfectly both solutions.

Once again, Thanks a lot

Marco Rod

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

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

Top