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