Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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. |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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. |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|