Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Lookup formula with dynamic sheet reference
I have a workbook with a summary worksheet and several weather data
worksheets. The data worksheets have unique names but all have the same structure. I would like to construct a formula that would lookup data for a specific day (refrenced in a column on the summary sheet) for a specific weather data worksheet (also listed in a column on the summary sheet). Is this possible? Have I given enough description of the circumstance? I have an idea that would utilize the "choose" function, but that would not be dynamic. -- William Blake |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Dynamic sheet reference | Excel Discussion (Misc queries) | |||
Formula with dynamic tab reference | Excel Discussion (Misc queries) | |||
Dynamic reference to another sheet? | Excel Worksheet Functions | |||
Dynamic reference to a sheet | Excel Worksheet Functions | |||
Dynamic reference to sheet name | Excel Worksheet Functions |