Sample file returned to Wayne, with ..

Implemented in "2005 Summary"
-----------------------------
Put in K20:

=OFFSET(INDIRECT("'"&CHOOSE(MONTH($K$3),"Jan","Feb ","Mar","Apr","May","Jun","Jul","Aug","Sep","Oct", "Nov","Dec")&"'!$AQ$9"),MATCH(DAY($K$3),INDIRECT(" '"&CHOOSE(MONTH($K$3),"Jan","Feb","Mar","Apr","May ","Jun","Jul","Aug","Sep","Oct","Nov","Dec")&"'!$A Q$10:$AQ$40"),0),COLUMNS($A$1:A1)-4)

Copy K20 across to M20

The formulas in K20:M20 will read the date in K3 (i.e. it reads the month
and the day in the date), and retrieve the values from the appropriate
monthly sheet, and from the row corresponding to the day in K3

Notes:
1. Cell K3 contained : =NOW()
2. Monthly sheets are named as: JAN, FEB, ... DEC
3. Range $AQ$10:$AQ$40 in each monthly sheet contains the numbers: 1. 2. ...
31
4. Corresponding lookup values to be retrieved were in 3 cols to the left of
$AQ$10:$AQ$40 in each monthly sheet, with the col positions corresponding to
"30 days", "90 days" and "12 mon" cols in "2005 Summary"

--
Rgds
Max
xl 97
---
GMT+8, 1° 22' N 103° 45' E
xdemechanik <atyahoo<dotcom
----