Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
I need to do a report in a workbook, the file is like this,
there are tabs for each year named 2005, 2006, etc. On each tab, there are quarters, like Q1 Q2 data1 data2 data1 data2 I'd like to link a data based on current quarter and year, for example, I want on Report sheet, A1 - 2006.Q2.data2 in which 2006 and Q2 are variables (referenced by names like CurY, CurQ). How to construct the lookup or offset? Thank you. |