how to find value on the cross of row and column

  • Thread starter Thread starter L.K.
  • Start date Start date
L

L.K.

Hi,

I have Excel table like this

C1 C2 C3 C4 . . .
A 1 5 5 7
B 2 8 6 8
C 5 7 1 9
D 7 5 7 10
E 9 4 7 9
F 6 5 5 5
..
..
..

I have big size table like this. How i can write formula or program to find
value in this table on the intersection of row and column.

Let i know column name value "C3" and row name value "D". how i can find
value on the intersection of this row and column?
Does exists such formula?

Thank you in advance,
Lado
 
Try this

=INDEX(A1:E7,MATCH(H2,A1:A7,0),MATCH(H1,A1:E1,0))

Where

H1 is the column header C3
H2 is the row D

Mike
 
Hi,

I have Excel table like this

C1 C2 C3 C4 . . .
A 1 5 5 7
B 2 8 6 8
C 5 7 1 9
D 7 5 7 10
E 9 4 7 9
F 6 5 5 5
.
.
.

I have big size table like this. How i can write formula or program to find
value in this table on the intersection of row and column.

Let i know column name value "C3" and row name value "D". how i can find
value on the intersection of this row and column?
Does exists such formula?

Thank you in advance,
Lado
Click to expand...

If you have "legal" name values, you can use the Intersection Operator
(<space>).

Of course, many of the "names" you have for your columns and rows are not
legal, but a formula like: =C3 D will return the value at the
intersection.

Translated into legal Excel names, the formula might really look like:

=_C3 D

Note the underscore prior to the C (since C is not a legal name).
--ron
 
Back
Top