Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Lookup
Trying to reference the data in a cell that matches Both a column heading and
row heading. |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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. |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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. |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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. |
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Matrix lookup/mulitple criteria lookup | Excel Discussion (Misc queries) | |||
Get Cell Address From Lookup (Alternative to Lookup) | Excel Worksheet Functions | |||
Join 2 Lists - Lookup value in 1 list & use result in 2nd lookup | Excel Worksheet Functions | |||
Sumproduct - Condition based on lookup of a Lookup | Excel Discussion (Misc queries) | |||
Pivot table doing a lookup without using the lookup function? | Excel Discussion (Misc queries) |