Lookup
 

Trying to reference the data in a cell that matches Both a column heading and
row heading.

Lookup
 

I am not use what you mean, maybe this?

http://www.contextures.com/xlFunctio...ml#IndexMatch2


--


Regards,


Peo Sjoblom



"MH" wrote in message
...
Trying to reference the data in a cell that matches Both a column heading
and
row heading.

Lookup
 

Thank you for referencing that website. Great resource!!

"Peo Sjoblom" wrote:

I am not use what you mean, maybe this?

http://www.contextures.com/xlFunctio...ml#IndexMatch2


--


Regards,


Peo Sjoblom



"MH" wrote in message
...
Trying to reference the data in a cell that matches Both a column heading
and
row heading.

Lookup
 

You can use a formula similar to the following:

=OFFSET($B$4,MATCH("z",B5:B8,0),MATCH("c",C4:F4,0) ,1,1)

This assumes that the row headings are in B5:B8 and the column
headings are in C4:F4. The formula looks for a row header of "z" and a
column header of "c". Change to suit your needs. Cell B4 is where the
row and column headers intersect. While the formula uses B4 as the
anchor for the OFFSET function, the contents (if any) of B4 are
entirely irrelevant. If a row and/or column header is not found, the
formula returns a #N/A error.

Cordially,
Chip Pearson
Microsoft Most Valuable Professional
Excel Product Group
Pearson Software Consulting, LLC
www.cpearson.com
(email on web site)


On Sat, 25 Oct 2008 12:00:04 -0700, MH
wrote:

Trying to reference the data in a cell that matches Both a column heading and
row heading.

Lookup
 

Hi,

As well as OFFSET, we commonly use INDEX:

=INDEX(B2:D10,MATCH(F1,B1:D1,),MATCH(G1,A2:A10,))

--
Thanks,
Shane Devenshire


"MH" wrote:

Trying to reference the data in a cell that matches Both a column heading and
row heading.