how to find value on the cross of row and column

[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

 

[Gary''s Student]

With your table in A1 thru E7:

=OFFSET(A1,MATCH("D",A:A),MATCH("C3",1:1))

 

[Mike H]

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

 

[L.K.]

Thank you it works fine!
Lado

 

[L.K.]

Thank you so much!
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

 

[Ron Rosenfeld]

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

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

 

[L.K.]

Thank you Ron,
It is very interesting decision.
Lado