Excel problem

[Jean]

I'm using Excel XP. I have a table with column and row
headings. I am trying to create a formula where I supply
the heading name and the row name; thus giving me the
value of the intersection of the two. Could anyone
help? Thanks.

 

[Peo Sjoblom]

=INDEX(A1:N50,MATCH(Rowheading,A1:A50,0),MATCH(Columnheading,A1:N1,0))
--
For everyone's benefit keep the discussion in the newsgroup.

Regards,

Peo Sjoblom

 

[Jean]

Thanks so much!

Jean

-----Original Message-----
=INDEX(A1:N50,MATCH(Rowheading,A1:A50,0),MATCH (Columnheading,A1:N1,0))
--
For everyone's benefit keep the discussion in the newsgroup.

Regards,

Peo Sjoblom





.

 

[Ron Rosenfeld]

I'm using Excel XP. I have a table with column and row
headings. I am trying to create a formula where I supply
the heading name and the row name; thus giving me the
value of the intersection of the two. Could anyone
help? Thanks.

<space> is the intersection operator.

Ensure you NAME your rows and columns appropriately. This can be done by
selecting the entire table, including the Row and Column names, then
Insert/Name/Create and check Top Row and Left column (assuming that's where
your labels are).

If you have the Row name in cell B24, and the Column name in cell B25, the
formula:

=INDIRECT(B24)<space>INDIRECT(B25)

will give the value at the intersection of this row and column.


--ron

 

[Soo Cheon Jheong]

Jean,

Table : A1:H15

Formula:


=OFFSET($A$1,MATCH(RowHeading,$A$2:$A$15,0),MATCH(ColumnHeading,$B$1:$H$1,0)
)


--
Regards,
Soo Cheon Jheong
Seoul, Korea
_ _
^¢¯^
--