The summary sheet contains a table of data columns B:L. The columns I:L are
where I am constructing my formulas. The date reference is in column E and
the sheet name reference is in column F.

The weather data sheets are setup in columns, with the date in column A and
the weather data (e.g. precipitation, wind speed, etc.) in the succeeding
columns.

I would like to set up a function to populate the summary sheet from the
cooresponding weather data sheet (which matches the sheet name reference in
column F of the summary table) with the data which cooresponds to the
appropriate date.

Is that more descript?
--
William Blake


"Pete_UK" wrote:

Not quite enough description - which cells in the summary sheet
contain the date and the worksheet name? What is the structure of the
data in the weather sheets, and what data do you want to return to the
summary sheet if you find a match?

You can do it with the INDIRECT function, and if you can answer the
other questions I'll be able to suggest an appropriate formula.

Pete

On Aug 13, 5:04 pm, William Blake
wrote:
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