Excel problem

  • Thread starter Thread starter Jean
  • Start date Start date
J

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.
 
=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
 
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





.
Click to expand...
 
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.
Click to expand...

<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
 
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
_ _
^¢¯^
--
 
Back
Top