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

With your table in A1 thru E7:

=OFFSET(A1,MATCH("D",A:A),MATCH("C3",1:1))
--
Gary''s Student - gsnu2007L

Thank you it works fine!
Lado


"Gary''s Student" wrote in message
...
With your table in A1 thru E7:

=OFFSET(A1,MATCH("D",A:A),MATCH("C3",1:1))
--
Gary''s Student - gsnu2007L

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." wrote:

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

Thank you so much!
Lado

"Mike H" wrote in message
...
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." wrote:

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

On Sat, 7 Mar 2009 12:33:54 -0000, "L.K." wrote:

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

Thank you Ron,
It is very interesting decision.
Lado

"Ron Rosenfeld" wrote in message
...
On Sat, 7 Mar 2009 12:33:54 -0000, "L.K." wrote:

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