Arrays

  • Thread starter Thread starter mary
  • Start date Start date
M

mary

I have an array with both column and row headings and want
to get the data in the particular cell that matches up to
my row/column characteristic. Example:

Week 1 Week2 Week3
Name 1
Name 2
Name 3

How can I pull in the cell for Name1/Week3 or Name 2/Week1?

Thanks
 
mary said:
I have an array with both column and row headings and want
to get the data in the particular cell that matches up to
my row/column characteristic. Example:

Week 1 Week2 Week3
Name 1
Name 2
Name 3

How can I pull in the cell for Name1/Week3 or Name 2/Week1?

Thanks
Click to expand...
If the headers are suitable as range names, select your data range,
including the row and column headers, click Insert|Name|Create and check
Top row and Left column. You can then use, e.g.

=Name2 Week3

Alan Beban
 
-----Original Message-----

If the headers are suitable as range names, select your data range,
including the row and column headers, click Insert|Name|Create and check
Top row and Left column. You can then use, e.g.

=Name2 Week3

Alan Beban
.
I'm actually trying to pull the information into other
Click to expand...
Excel Addins. I've named the table and want to reference
the table throughout the rest of the spreadsheet.
 
mry said:
I'm actually trying to pull the information into other
Excel Addins. I've named the table and want to reference
the table throughout the rest of the spreadsheet.
Click to expand...

If your header names are unique in the workbook, I don't see the
relevance, and would renew my original answer. What am I missing?

Alan Beban
 
Thanks for helping me out!

What I'm actually trying to do is this:
I have two characteristics on one sheet, ie, Name and
Week, and am trying to pull in the particular cell from
the array that corresponds to each unique name/week
combo. I tried to do this with Lookup, VLookup or HLookup
but get myself in a circle.

At any given time, the two characteristics can change, so
my equation has to be amenable to allow for any
combination.

Hope this clears it up.
Mary
 
Well, I still don't quite see how you will be calling the data in
practice, with your table in A1:D4, a name in H1 and a week in I1, if
you have created the row and column headers as names as I previously
described

=INDEX(INDIRECT(H1),MATCH(I1,$B$1:$D$1,0))

will return the value at the intersection of the name and week.

That's my last try.

Alan Beban
 
Back
Top