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. |