Intercept and Indirect
 

Sorry but I am getting hung up on these intercept and indirect functions
as I thought they would be the ones to use in this situation but I
cannot get them to work. I have an array with column headings, 1,2,3,4
etc which are actually weeks. The rows are letters , A, B, C, etc which
identify cottages. If I enter C in cell A1 for example, and 21 in cell
B1, what I want it to do is look for the cell in week 21 for cottage C
and identify the value in that cell. I thought I could name each row and
column then use the indirect function from cells A1 and B1 to then look
for the intercept where the named column and row meets.
I would value any guidance to see if this is the way I should be doing it.

Regards
Graham Haughs
Turriff
Scotland.

Intercept and Indirect
 

your array is A2:Y18
=VLOOKUP(A1,A2:Y18,MATCH(B1,A2:Y2,0),FALSE),will give you the intersection
of c and 21

--
paul
remove nospam for email addy!



"Graham Haughs" wrote:

Sorry but I am getting hung up on these intercept and indirect functions
as I thought they would be the ones to use in this situation but I
cannot get them to work. I have an array with column headings, 1,2,3,4
etc which are actually weeks. The rows are letters , A, B, C, etc which
identify cottages. If I enter C in cell A1 for example, and 21 in cell
B1, what I want it to do is look for the cell in week 21 for cottage C
and identify the value in that cell. I thought I could name each row and
column then use the indirect function from cells A1 and B1 to then look
for the intercept where the named column and row meets.
I would value any guidance to see if this is the way I should be doing it.

Regards
Graham Haughs
Turriff
Scotland.

Intercept and Indirect
 

Belated thanks for that help Paul.

Graham

paul wrote:
your array is A2:Y18
=VLOOKUP(A1,A2:Y18,MATCH(B1,A2:Y2,0),FALSE),will give you the intersection
of c and 21